Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2009
    Posts
    67
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Line chart-changing x axis data

    I have a chart where the data points for the X axis start at .25 and go to .95. When I create the chart the X axis changes from 1 to 15 instead of plotting the exact data points. I tried to edit the data points in formatting but it reverts to a whole number. Is there a way to change the X axis to use the exact data instead of whole numbers? I have attached a copy of the spreadsheet. The chart is base on the data from column A & B.

    Thanks,

    Mike
    Attached Images Attached Images

  2. #2
    3 Star Lounger Supershoe's Avatar
    Join Date
    Apr 2014
    Location
    Austin, TX
    Posts
    252
    Thanks
    1
    Thanked 36 Times in 34 Posts
    You can set a min/max and increments or use data labels for each point

  3. #3
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,631
    Thanks
    115
    Thanked 645 Times in 589 Posts
    Mike,

    Right click on the chart> Select Data...> Edit (Right pane)> Click the selector on the right side of input box and drag A2 to A16> OK> OK

    HTH,
    Maud

    Chart Data.png

    Chart Data2.png

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •