Chart from PivTbl, WITHOUT PivChart?
 

I've been trying for hours. How do you make a chart from PivotTable
data WITHOUT using/going through a PivotChart? I cannot seem to get the
control I want over the graph - the PivotChart assumes too many things.

Dick Penny


--
dpenny
------------------------------------------------------------------------
dpenny's Profile: http://www.excelforum.com/member.php...o&userid=19708
View this thread: http://www.excelforum.com/showthread...hreadid=556090

Chart from PivTbl, WITHOUT PivChart?
 

Dick -

Select a cell somewhere outside of the pivot table. Use Step 1 of the Chart
Wizard to choose the chart type. In step 2 use Chart Source Data Series to
specify the data ranges. Etc.

- Mike
www.mikemiddleton.com

"dpenny" wrote in
message ...

I've been trying for hours. How do you make a chart from PivotTable
data WITHOUT using/going through a PivotChart? I cannot seem to get the
control I want over the graph - the PivotChart assumes too many things.

Dick Penny


--
dpenny
------------------------------------------------------------------------
dpenny's Profile:
http://www.excelforum.com/member.php...o&userid=19708
View this thread: http://www.excelforum.com/showthread...hreadid=556090