2 Axis Pivot Table Based Chart Problem

  • Thread starter Thread starter Ted Pearlman
  • Start date Start date
T

Ted Pearlman

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
 
To plot a series on the secondary axis:

1. Select the series that you want on the secondary axis
2. Choose Format>Selected 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.
 
Back
Top