+ Reply to Thread
Results 1 to 7 of 7

Chart X axis values coming up as black blob

  1. #1
    Forum Contributor
    Join Date
    06-25-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    179

    Chart X axis values coming up as black blob

    Hello All,
    Really simple question
    I have 16000 dates coming from a pivot table as my x axis.
    This causes it to freak out.
    How do i get it to appear as just years instead of it trying to print all 16000 dates?
    This is what it looks like atm. Graph.jpg

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,354

    Re: Chart X axis values coming up as black blob

    I'm not sure if it matters, but is this a line chart or an XY scatter plot?

    Have you tried changing the number format for the x axis so it only shows years?

  3. #3
    Forum Contributor
    Join Date
    06-25-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    179

    Re: Chart X axis values coming up as black blob

    Its a line. its set to just year but i still get 4 large black lines across the bottom.

    Regards,
    Joshua

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

    Re: Chart X axis values coming up as black blob

    Are the dates grouped in anyway within the pivot table?

    The blobs are just all the date texts overlapping each other.
    Cheers
    Andy
    www.andypope.info

  5. #5
    Forum Contributor
    Join Date
    06-25-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    179

    Re: Chart X axis values coming up as black blob

    unfortunatley they are not its just a list of dates from 2007 to now. how can i group them in the x axis label without grouping the actual data?

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

    Re: Chart X axis values coming up as black blob

    Try formatting the axis and altering the Interval between Labels.

  7. #7
    Forum Contributor
    Join Date
    06-25-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    179

    Re: Chart X axis values coming up as black blob

    ty problem solved

+ 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