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. |
I feel stupid now...
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/so...art/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 "vjromeo" wrote: 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. |
All times are GMT +1. The time now is 03:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com