secondary category axis reset to min=0 max=0 on save

  • Thread starter Thread starter vjromeo
  • Start date Start date
V

vjromeo

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.
 
This morning I got poking around to see what VBA was in this Excel file and
notice a module called "Auto_ChartAxes". I'd forgotten that I'd installed
this a couple weeks ago--it is Tushar Mehta's AutoChart Manager
(http://www.tushar-mehta.com/excel/software/autochart/index.html)
which was behaving exactly as it should, since yesterday I moved the cells
it was using to adjust the axis. (I converted that axis to use a fixed scale
of 1 to 1001, and scale my data accordingly.)

Sorry for the time anyone else may have spent trying to figure this one out.

Thanks,
-Vince
 
Back
Top