Unlinked Chart Treats Time Axis As Value - Any Fix?

  • Thread starter Thread starter Robert Smith
  • Start date Start date
R

Robert Smith

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
 
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
 
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.
 
Back
Top