+ Reply to Thread
Results 1 to 2 of 2

Scatter Graph X Asis Issue

  1. #1
    Registered User
    Join Date
    09-11-2012
    Location
    Tulsa, Oklahoma
    MS-Off Ver
    Vista
    Posts
    1

    Scatter Graph X Asis Issue

    I was hoping someone could help me with a scatter graph question. On the X Axis the data point is not lining up correctly with the tic mark. I was trying to use dates, i.e., August 1st thru August 31st, and was showing them as the numbers 1-31 in the graph. The data points are lining up one off. The date and assoicated information for the first is aligning with the tic mark for the 2nd. How do I correct this? I have attached a copy of my spreadsheet. Thank you for any help you can give me with this.

    Anne H.

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

    Re: Scatter Graph X Asis Issue

    Your main problem is that you have included the column headers in the data range of each series rather than as its Name.

    I have adjusted the series range references to begin in row 2 rather than row 1 and set the Name to row 1 of relevant column.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ 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