+ Reply to Thread
Results 1 to 2 of 2

a-axis labeling issues

  1. #1
    Registered User
    Join Date
    09-17-2010
    Location
    Washington DC
    MS-Off Ver
    Excel 2007
    Posts
    23

    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
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: a-axis labeling issues

    Hello,

    add a new column to your data this formula

    =IF(C6=C5,NA(),0)

    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.

    cheers,

    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)

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