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.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Creating Graph in Excel With Pivot Tables

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Creating Graph in Excel With Pivot Tables
 Login/Join
 
Goldy
Silver Member
posted
Hi,

Can anybody give me idea how to create graph in excel with pivot tables ? If anybody have any example then it's more helpful for me.....

Thanks in advance...........
 
Posts: 30 | Location: India | Registered: February 23, 2005Report This Post
Boogarweed
Gold member
posted Hide Post
This example is right off the support website. I hope it helps....

TABLE FILE CAR
HEADING
"Inventory Report"
" "
PRINT SALES
BY COUNTRY
ON TABLE SET STYLE *
type=heading, size=18, $
ENDSTYLE
ON TABLE PCHOLD FORMAT EXL2K PIVOT
PAGEFIELDS TYPE SEATS
CACHEFIELDS MODEL MPG RPM
END
 
Posts: 90 | Location: Tinker AFB | Registered: June 03, 2003Report This Post
<JG>
posted
what Boogarweed should have added is that to see it as a graph go to insert on the menu bar and select chart.
This will automatically insert a pivot chart into a new sheet.
To do it automatically you will need to incorporate a simple macro into the pivot table before WebFocus delivers it to the user. That can be done automatically in 7.1 when it becomes available but has to be done programatically for earlier releases.
 
Report This Post
Goldy
Silver Member
posted Hide Post
Hi,

Thanks JG & Boogarweed for reply. Also I have one problem.. Can I set graph in excel sheet anywhere instead of footer? is't possible? like HTML & PDF..

Thanks & Regards,
Goldy
 
Posts: 30 | Location: India | Registered: February 23, 2005Report This Post
<JG>
posted
Yes it's possible to position a graph anywhere you want using a macro but you would not normally include a graph into the same sheet as a pivot table.
The reason is that as you change the dimensions of the report, parts of it can be obscured by the graph. The graphs and table interact so as you change the dimensions of one the other also changes.
 
Report This Post
Mary Watermann
Gold member
posted Hide Post
quote:
Originally posted by Goldy:
Hi,

Can anybody give me idea how to create graph in excel with pivot tables ? If anybody have any example then it's more helpful for me.....

Thanks in advance...........


Goldy .. Did you ever find how to create a Pivot Chart through FOCUS? I need the same technique.


WF 7.6.10, Windows, PDF, Excel
 
Posts: 75 | Location: Dallas, TX | Registered: February 12, 2004Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Creating Graph in Excel With Pivot Tables

Copyright © 1996-2020 Information Builders