+ Reply to Thread
Results 1 to 4 of 4

Prevent Graphs from auto populating dates not present in Table

  1. #1
    Registered User
    Join Date
    02-26-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2010
    Posts
    21

    Prevent Graphs from auto populating dates not present in Table

    I have a series of dates( Excluding weekends) but when i am creating a graph for these dates it is showing the weekends as well.( Which actually is not present in my table), is there a way around this?

    PFA for further understanding
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    04-03-2012
    Location
    East Sussex, UK
    MS-Off Ver
    Excel 2003:2010
    Posts
    893

    Re: Prevent Graphs from auto populating dates not present in Table

    Right click the dates on the X axis and select "format axis".
    Then in the dialogue box that appears select "text axis" rather than "automatic".
    If I've been of help, please hit the star

  3. #3
    Registered User
    Join Date
    02-26-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2010
    Posts
    21

    Re: Prevent Graphs from auto populating dates not present in Table

    Thanks a lot....reps added...

  4. #4
    Valued Forum Contributor
    Join Date
    04-03-2012
    Location
    East Sussex, UK
    MS-Off Ver
    Excel 2003:2010
    Posts
    893

    Re: Prevent Graphs from auto populating dates not present in Table

    No problem. Glad to help. Thanks for the rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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