Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Set uniform scaling for same type of Pivot charts with varying dat
Good afternoon;Excel 2003, windows XP.
I run pivot tables and charts every week based on the same data. The data is for every one in the department. I then do a pivot table from the data for each sub department , based on the employee names in each sub department. The data structure is always the same for all the pivot tables, however, when I plot the charts from the pivot tables, the scaling changes based on the data. Is there a set fixed scaling so the chart size, (Bars, etc.), that represents each pivot table, will look the same regardless of the change of data. These are 3-D Column Charts. Thanks in advance for any suggestion that may help. Can this be done or is it necessary for the scaling to fluctuate with the change of data. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Set uniform scaling for same type of Pivot charts with varying dat
Hi,
You can maintain some pivot chart features: For example, double-click the Y-axis and choose the Scale tab, uncheck Auto and set the values you want for min, max, ... You also have some control of the X-axis based on the them technique. But not everything is controlable. -- If this helps, please click the Yes button Cheers, Shane Devenshire "AuthorizedUserPF" wrote: Good afternoon;Excel 2003, windows XP. I run pivot tables and charts every week based on the same data. The data is for every one in the department. I then do a pivot table from the data for each sub department , based on the employee names in each sub department. The data structure is always the same for all the pivot tables, however, when I plot the charts from the pivot tables, the scaling changes based on the data. Is there a set fixed scaling so the chart size, (Bars, etc.), that represents each pivot table, will look the same regardless of the change of data. These are 3-D Column Charts. Thanks in advance for any suggestion that may help. Can this be done or is it necessary for the scaling to fluctuate with the change of data. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pie Charts - Scaling | Charts and Charting in Excel | |||
Auto Scaling Charts | Charts and Charting in Excel | |||
Dynamic Scaling for Charts | Charts and Charting in Excel | |||
Logarithm scaling for charts | Charts and Charting in Excel | |||
Varying axis scaling | Charts and Charting in Excel |