Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Excel Discussion (Misc queries) | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Adding data on Axis Major Gridlines next to Category Axis Collums | New Users to Excel | |||
Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another | Charts and Charting in Excel |