+ Reply to Thread
Results 1 to 5 of 5

series data point not matching up with gridline on axis

  1. #1
    Forum Contributor
    Join Date
    04-08-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    101

    series data point not matching up with gridline on axis

    As you can see on the example this chart isn't matching the data ??? what is going on and how do I fix.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,618

    Re: series data point not matching up with gridline on axis

    Maybe a bar chart
    Attached Files Attached Files
    Ben Van Johnson

  3. #3
    Forum Contributor
    Join Date
    04-08-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    101

    Re: series data point not matching up with gridline on axis

    thanks, I like the bar chart.. I actually had to create all the charts from scratch.. but it is killing me not knowing why or what is going on with this one and WHY can't I fix it... lol ... :o) Thanks for the reply, I appreciate you. LaDonna

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

    Re: series data point not matching up with gridline on axis

    You use Stacked Line chart style for that series
    Cheers
    Andy
    www.andypope.info

  5. #5
    Forum Contributor
    Join Date
    04-08-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    101

    Re: series data point not matching up with gridline on axis

    I can't believe it was that simple of a fix, good grief. Thanks Andy... LaDonna

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] The number of a data point in a series
    By dindea in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 10-23-2012, 10:07 AM
  2. [SOLVED] Radar Chart - How to include X axis gridline
    By Michelle in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-07-2005, 05:35 AM
  3. Single Data Point on a new Series
    By bocjoel in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-15-2005, 12:35 PM
  4. Format Gridline (BOLDING) and Changing Axis Labels
    By hokieguy in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-08-2005, 04:35 PM
  5. start new series at mid point of x axis
    By derekbrown in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-17-2005, 06:23 PM

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