Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Natalia Kozyura
 
Posts: n/a
Default 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

  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Problems Rachel Gonsior Excel Discussion (Misc queries) 3 March 21st 05 08:24 PM
How to increase the size of a Pivot Table Graph cdavidson Excel Discussion (Misc queries) 1 March 16th 05 04:20 PM
How do I create a pivot table if the pivot table icon or menu ite. Lynn@WS Charts and Charting in Excel 1 December 16th 04 03:36 AM
How to create a calculated field formula based on Pivot Table resu dha17 Excel Discussion (Misc queries) 1 December 15th 04 06:39 AM
create space in line chart between points, linked to pivot table Mike -Z- Charts and Charting in Excel 1 December 7th 04 10:39 PM


All times are GMT +1. The time now is 07:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"