How do you create a complicated pivot table graph?
 

I am trying to create a little bit complicated pivot table graph with many
trend lines and bars. So far I was able to create a basic graph but can not
create anything complicated. Please assist.
Regards,

Natalia

Hi Natalia -

Pivot tables are very useful, but my experience is that in all but the
most simple cases, pivot charts are limited and limiting. I make regular
charts from pivot table data all the time. Excel has a tendency to
assume that you're using a pivot table for the data, so you must want a
pivot chart; as long as you avoid this tendency, you'll be fine.

Start by selecting a blank cell away from the pivot table. Start the
chart wizard, and select the chart type, then in step 2 click on the
Series tab, and define the ranges for your series one by one. If you
tried to define the entire chart source from the Data Range tab, you
would end up in PivotChartLand.

You can now add any of your favorite embellishments to the chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Natalia Kozyura wrote:

I am trying to create a little bit complicated pivot table graph with many
trend lines and bars. So far I was able to create a basic graph but can not
create anything complicated. Please assist.
Regards,

Natalia