Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
Charts again
 Login/Join
 
Karanth
Platinum Member
posted
My project requires the following:
1) Display of pi charts - possible!!!
2) Mouse over on the pie labels should show some other value - is it possible????
3) Option to save it as an Excel - is it possible???

Pls respond!!!!
 
Posts: 109 | Registered: January 31, 2006Report This Post
Tony A
Expert
posted Hide Post
Karanth,

1) Yes, use a graphtype of between 55 and 60.

2) Again, Yes. Look at the programming methods within the graphing manual to determine what you need to program into your fex between -
ON GRAPH SET GRAPHSTYLE *
-* Pie chart
set GraphType(55);
ENDSTYLE

Create a prototype and run it, using "-SET &ECHO=ALL;", to HTML output and examine the HTML source

3) If you are outputing to Excel then you will need to save the image on your network in a location that is accessable to your Web Client, and then place an HREF to it in your Excel output.

For instance on Windows, create a network share on your client server pointing at //servername/install folder/IBI/WebFOCUS53/IBI_HTML called IBI_HTML. Create a new directory under IBI_HTML and call it tempcharts, and then you can code -
FILEDEF mygraph DISK //servername/IBI_HTML/tempcharts/mygraph.gif
-RUN

GRAPH FILE CAR
SUM RCOST
    DCOST
BY COUNTRY
ON GRAPH SET GRAPHEDIT OFF
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET GRID OFF
ON GRAPH SET GRMERGE ON
ON GRAPH SET VAXIS 200
ON GRAPH SET HAXIS 200
ON GRAPH SET GRAPHSTYLE *
setGraphType(55);
ENDSTYLE
ON GRAPH HOLD AS mygraph FORMAT GIF
END
-RUN
-Graph
DEFINE FILE CAR
  GRAPH/A100 = '<IMG BORDER=0 SRC=/IBI_HTML/tempcharts/mygraph.gif>';
END
TABLE FILE CAR
SUM RCOST
    DCOST
BY COUNTRY
FOOTING
"<GRAPH"
ON TABLE PCHOLD FORMAT EXL2K
END


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
<JG>
posted
If you save the graph as an image then the mouse over does not work.
They must be either applet or HTML, neither of which can go into an Excel document.
 
Report This Post
Karanth
Platinum Member
posted Hide Post
Thanks a lot. Great suggestions!!!
 
Posts: 109 | Registered: January 31, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders