+ Reply to Thread
Results 1 to 3 of 3

Unlinked Chart Treats Time Axis As Value - Any Fix?

  1. #1
    Robert Smith
    Guest

    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

  2. #2
    Tushar Mehta
    Guest

    Re: Unlinked Chart Treats Time Axis As Value - Any Fix?

    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 <[email protected]>,
    [email protected] 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
    >


  3. #3

    Re: Unlinked Chart Treats Time Axis As Value - Any Fix?

    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 <[email protected]>,
    > [email protected] 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1