+ Reply to Thread
Results 1 to 2 of 2

a-axis labeling issues

  1. #1
    Registered User
    Join Date
    Washington DC
    MS-Off Ver
    Excel 2007

    a-axis labeling issues

    The graph displays the distribution rate that a company pays out. On the x-axis, I'd like to have the start date, the end date and any date when the distribution rate changes. I'm struggling to get this x-axis to label correctly. Thanks for the help.
    Attached Files Attached Files

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast

    Re: a-axis labeling issues


    add a new column to your data this formula


    Manually change the last value to 0.
    Add this data to your chart as a new series.
    Change that new data series to be a XY Scatter chart.
    Display the secondary X axis and format it to the same min and max values as the primary X axis.
    Format the primary X axis to have no data labels and no tick marks
    download and install the free XY Chart Labeler tool available at http://www.appspro.com/Utilities/ChartLabeler.htm and use it to label the data points for the new data series with the dates in column B
    Format the data markers with a symbol of your choice, for example a + sign to emulate the axis ticks.

    See attached.


    Edit: forgot this step: Hide the secondary Y axis
    Attached Files Attached Files
    Last edited by teylyn; 03-09-2011 at 07:01 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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