LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posts: n/a
Default Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis

Even after googling for a while I cannot find anyone with the same
problem, so here it is:

if generating a Line Chart out of a Pivot Table with Page fields, AND
using a Secondary Y Axis in the line chart to separate 2 or more
curves, this secondary Y axis disappears as soon as any Page Field
value is reselected or changed!
I'd call this a serious bug.

Depending on the Excel versions I tried the effect is different, but
destructive to that Y2 association:
- in Excel 2002 (SP2) all curves of the Line Chart are associated with
the Primary Y axis, the secondary one disappears
- in Excel 2000 the LABELS of BOTH Y axes disappear (even worse as the
curves can no longer associated with each scale)

The only way to get the Secondary Y Axis back is to select any curve
and change "Axis" in the "Format Series" menu.

Is there any official fix for this or a work-around.
We generate these charts programmatically through VB/VBA and need it
work reliably.

michael walter

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Exclude pivot table data from pivot chart? coal_miner Charts and Charting in Excel 4 April 17th 07 07:11 AM
Stacked Bar Chart with Secondary Axis Benjamin B Charts and Charting in Excel 7 May 15th 05 04:00 AM
How do I set permanent secondary axis in PivotTable chart? Microlong Charts and Charting in Excel 3 January 8th 05 03:54 AM
create space in line chart between points, linked to pivot table Mike -Z- Charts and Charting in Excel 1 December 7th 04 09:39 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM

All times are GMT +1. The time now is 09:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"