View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
vjromeo vjromeo is offline
external usenet poster
 
Posts: 2
Default secondary category axis reset to min=0 max=0 on save

I have a combination stacked column, line, XY chart with all of the stacked
columns and a line on the primary axis, and another line and XY plotted
against the secondary (X & Y) axis. The secondary category (x) axis is a
time-scale manually set to 1/1/2006 - 2/29/2008, with a base unit of 1 day.
The chart is great except that when I try to save (or close & save) it, the
secondary x axis is reset to min=0 & max=0, so everything plotted against the
secondary axis effectively disappears. I can reopen the chart and set the
secondary x axis to the appropriate date range and everything is back, until
I save/close the file again. Anyone seen anything like this? Any
suggestions?
What makes in even more bizarre is I have another chart that's virtually
identical (in fact, the series plotted on the secondary axis are identical)
except that there are 4 series in the stacked columns (as opposed to 7)
plotted against the primary axis, and this other chart has no problem when I
save/close the file.

Thanks in advance for any help you can offer.