+ Reply to Thread
Results 1 to 3 of 3

Manage x-axis labels in a dynamic chart?

  1. #1
    Registered User
    Join Date
    05-07-2011
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2013
    Posts
    59

    Manage x-axis labels in a dynamic chart?

    Hello:

    I used this nifty tutorial to build a dynamic chart: http://pubs.logicalexpressions.com/P...cle.asp?ID=246

    Everything is great except for one thing: My x-axis, which pulls from column A of my data sheet, consists of dates, each a week apart. I.e. 1/7/2012, 1/14/2012, and so forth.

    However when I set the dynamic chart for a smaller date range, the x-axis on the chart will populate with labels one day apart. For example 1/7/2012, 1/8/2012, 1/9/2012, and so on. I do not want those extra dates, How do I get it to to populate the dynamic chart with x-axis labels with just the actual dates from my data sheet, and not those extras?

    Thanks

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Manage x-axis labels in a dynamic chart?

    That's nothing to do with dynamic ranges but rather the x axis being treated as Date (Time Series) axis.

    Format the axis to be Category rather than Time Series. Right click chart and pick Chart Options > Axes.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    05-07-2011
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2013
    Posts
    59

    Re: Manage x-axis labels in a dynamic chart?

    Perfect; thank you

+ 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