Graphs from pivot table

cashmire · Mar 27th, 2002, 09:24 AM

I have been busting my *** on creating a graph from data in a pivot table without the graph becoming a pivot graph. What I do want is the graph to change according to the selection I make in the pivottable. Can you help?

Mark W. · Mar 27th, 2002, 05:58 PM

On the PivotTable toolbar click on the PivotChart dropdown list and select the "Hide PivotChart Field Buttons" option.

cashmire · Mar 28th, 2002, 04:35 AM

Mark,

Thanks for your reply. I just tried it but its not really working. To give you an idea of what I am trying to do...I have several columns with YTD revenue, sales, budget revenue, budget sales, etc. I also make a distiction between region, month, Q, H1/H2 account. Now what I am trying to do is that when I change the pivottable to show a certain account in a certain month/Q/H that the table changes as well. So far that has not been working. What happened was that I get to see bookings and revenue in one graph and I want to split them over 2 graphs but keeping the single pivottable.

Any suggestions?

Mark W. · Mar 28th, 2002, 11:16 AM

Either produce separate PivotTables with only the data needed for each chart. Or, use the GETPIVOTDATA worksheet function to extract only the data needed for each chart.

[ This Message was edited by: Mark W. on 2002-03-28 10:18 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 27th, 2002, 09:24 AM	#1
cashmire New Member Join Date: Mar 2002 Location: Malaysia Posts: 30	I have been busting my *** on creating a graph from data in a pivot table without the graph becoming a pivot graph. What I do want is the graph to change according to the selection I make in the pivottable. Can you help?

Mar 27th, 2002, 05:58 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	On the PivotTable toolbar click on the PivotChart dropdown list and select the "Hide PivotChart Field Buttons" option.

Mar 28th, 2002, 04:35 AM	#3
cashmire New Member Join Date: Mar 2002 Location: Malaysia Posts: 30	Mark, Thanks for your reply. I just tried it but its not really working. To give you an idea of what I am trying to do...I have several columns with YTD revenue, sales, budget revenue, budget sales, etc. I also make a distiction between region, month, Q, H1/H2 account. Now what I am trying to do is that when I change the pivottable to show a certain account in a certain month/Q/H that the table changes as well. So far that has not been working. What happened was that I get to see bookings and revenue in one graph and I want to split them over 2 graphs but keeping the single pivottable. Any suggestions?

Mar 28th, 2002, 11:16 AM	#4
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Either produce separate PivotTables with only the data needed for each chart. Or, use the GETPIVOTDATA worksheet function to extract only the data needed for each chart. [ This Message was edited by: Mark W. on 2002-03-28 10:18 ]