Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combined bar/Line graph defaults to bar
In Excel 2007 I have a Combined bar/Line graph get it's data from a pivottable.
Intermittently, when I change the pivottable filters, the combined bar/Line graph defaults to just a bar graph. I have tried 2 approaches with the same results - 1. Have the graph select each set of data from a range 2. Have the graph point generically at the pivottable and dynamically adjust itself -- Thank You in Advance, Michael Anderson |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combined bar/Line graph defaults to bar
Pivot charts are notorious for resetting their formatting when the table is
refreshed or re-pivoted. What you have to do is change each series: right click on the series, then select Change Type. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Michael Anderson" wrote in message ... In Excel 2007 I have a Combined bar/Line graph get it's data from a pivottable. Intermittently, when I change the pivottable filters, the combined bar/Line graph defaults to just a bar graph. I have tried 2 approaches with the same results - 1. Have the graph select each set of data from a range 2. Have the graph point generically at the pivottable and dynamically adjust itself -- Thank You in Advance, Michael Anderson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
scatter and line combined | Charts and Charting in Excel | |||
combined line-column excel chart | Charts and Charting in Excel | |||
combined scatter plot and line data | Excel Discussion (Misc queries) | |||
Combined line/stacked column chart | Charts and Charting in Excel | |||
How do you change sort defaults for combined text number & hyphen. | Excel Discussion (Misc queries) |