+ Reply to Thread
Results 1 to 7 of 7

Chart Data Points Not Lining up with Axis

  1. #1
    Registered User
    Join Date
    08-07-2008
    Location
    Seattle
    Posts
    28

    Chart Data Points Not Lining up with Axis

    Hi-

    I have a bar/scatterplot chart where the scatter plot dots are supposed to line up with the bars. For most of my co-workers this seems to work fine. But for me the dots are somewhat scrunched together and not lining up properly. Any suggestions?

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Chart Data Points Not Lining up with Axis

    It might be more helpful if you posted your workbook with the chart.

  3. #3
    Registered User
    Join Date
    08-07-2008
    Location
    Seattle
    Posts
    28

    Re: Chart Data Points Not Lining up with Axis

    I have attached an example. It is a screenshot of the actual chart since these same charts render properly on every computer other than mine. Thanks for having a look.
    Attached Files Attached Files

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: Chart Data Points Not Lining up with Axis

    Hmmm, difficult to tell from the screenshots only. Could you also post the data. Even if the resulting charts line up correctly, we could have a play....

  5. #5
    Registered User
    Join Date
    08-07-2008
    Location
    Seattle
    Posts
    28

    Re: Chart Data Points Not Lining up with Axis

    here is the actual xls.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    08-07-2008
    Location
    Seattle
    Posts
    28

    Re: Chart Data Points Not Lining up with Axis

    Hi - Has anyone gotten a chance to look at the spreadsheets I posted? I would greatly appreciate any help.

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

    Re: Chart Data Points Not Lining up with Axis

    Like your co-workers the charts look fine to me.

    Have you check which version of excel they/you have. Perhaps you need a service pack update.
    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)

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