If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|