Chart from PivTbl, WITHOUT PivChart?

D

dpenny

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
 
M

Mike Middleton

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a secondary Axis to a graph 2
chart legen moves! 5
reversing the axis on a chart 2
Pivot Chart: cannot apply the default chart type... 1
Chart Type changes when I pivot 1
Pivot Chart - Disassocoation from PivotTable 1
Color gradient problem on X-Y chart 2
Excel Excel Pivot Chart/Pivot Table query 0

Top