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
|
|||
|
|||
2 Axis Pivot Table Based Chart Problem
Hi,
I have a Pivot Table with 6 data types. 1 has a wide scale, say 1 - 100,000. The other 5 data types have a scale that is narrow, say 1 - 20. After I create the Pivot Chart from the Pivot Table and choose a "Line - Column on 2 Axes" type chart, Excel assigns the first 3 data types to the scale on the left (which happens to be the small scale) and the other 3 data types to the large scale, even though 2 of those last 3 are small scale data types. So, the result is 2 data series displaying as if they are zero, because their values are things like 3, 7, 11, 0.5, yet Excel has forced them to display on the 1 - 100,000 scale. Any way around this? VB would be fine. Thanks, Ted |
#2
|
|||
|
|||
2 Axis Pivot Table Based Chart Problem
To plot a series on the secondary axis:
1. Select the series that you want on the secondary axis 2. Choose FormatSelected Data Series 3. On the Axis tab, select Secondary Axis. 4. Click OK When you refresh the pivot chart, the formatting will be lost. You could record a macro as you refresh the pivot chart, and format the series. Then run the macro as required. Ted Pearlman wrote: Hi, I have a Pivot Table with 6 data types. 1 has a wide scale, say 1 - 100,000. The other 5 data types have a scale that is narrow, say 1 - 20. After I create the Pivot Chart from the Pivot Table and choose a "Line - Column on 2 Axes" type chart, Excel assigns the first 3 data types to the scale on the left (which happens to be the small scale) and the other 3 data types to the large scale, even though 2 of those last 3 are small scale data types. So, the result is 2 data series displaying as if they are zero, because their values are things like 3, 7, 11, 0.5, yet Excel has forced them to display on the 1 - 100,000 scale. Any way around this? VB would be fine. Thanks, Ted -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|