Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Unlinked Chart Treats Time Axis As Value - Any Fix?
I have a series of charts in separate workbooks, all with a time
X-axis. For distribution, I copy just the charts - not the underlying data - to a new workbook. All looks good until I come to open the new workbook, when I find that the Y-axis has migrated from outside left to inside right, and buggered up the alignment with a second chart on the same sheet. When I look at the properties of the X-axis, I find that it's no longer a time axis, but a value axis; and that, instead of the Y-axis crossing at 8/1/2004, it now crosses at 27338 - even though the X-axis is still formatted as a date. I can't find any way to force Excel to treat the X-axis as a date, and I can't figure a way to make my other charts put their Y-axis text inside the chart on the left. If I could do either of these things, I could make my two charts match up again. Any idea how to do this? Ta Robert Smith |
#3
|
|||
|
|||
Not an option, I'm afraid. These charts are coming out of a macro, and
there are around 150 charts each day. Plus it loses the capability of seeing exact values by mousing over the chart. The best compromise I've come up with so far is to simply force the axis to display inside the plot space on the right-hand side. This I achieved by setting the category axis's .CrossesAt property to the maximum value on that axis - don't ask me why it doesn't put the axis on the OUTside of the plot area, but it doesn't. Then, to get my second chart to match - they're vertically aligned, so I don't want to waste space displaying a category axis - , I had to set ..HasAxis(xlCategory, xlPrimary) = True, then set .Axes(xlCategory, xlPrimary).CrossesAt to the maximum value, then set ..HasAxis(xlCategory, xlPrimary) = False. Axis on, set value axis to far right, axis off. It doesn't explain why Excel feels it necessary to move my value axis from left to right in the first place - o for a way to stop Excel "thinking" for itself -, but it does give me a workable solution. Tushar Mehta wrote: Consider copying the chart as an image. With the chart selected, hold down the SHIFT key and select Edit | Copy Picture... -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I have a series of charts in separate workbooks, all with a time X-axis. For distribution, I copy just the charts - not the underlying data - to a new workbook. All looks good until I come to open the new workbook, when I find that the Y-axis has migrated from outside left to inside right, and buggered up the alignment with a second chart on the same sheet. When I look at the properties of the X-axis, I find that it's no longer a time axis, but a value axis; and that, instead of the Y-axis crossing at 8/1/2004, it now crosses at 27338 - even though the X-axis is still formatted as a date. I can't find any way to force Excel to treat the X-axis as a date, and I can't figure a way to make my other charts put their Y-axis text inside the chart on the left. If I could do either of these things, I could make my two charts match up again. Any idea how to do this? Ta Robert Smith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please help me, losing hair (chart with 2 data against time) | Charts and Charting in Excel | |||
Formatting dates on x axis of chart...! | Excel Discussion (Misc queries) | |||
How do I set permanent secondary axis in PivotTable chart? | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel |