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

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