close

Privacy guaranteed - Your email is not shared with anyone.

How do you make an Excel graph so the X-axis is to scale with the data?

Discussion in 'Tech Talk' started by Originalsin, Jun 10, 2010.


  1. Originalsin

    Originalsin
    Expand Collapse

    Joined:
    Dec 1, 2000
    479
    0
    Location:
    Australia.
    Hi all,

    I'm trying to plot some data I have on Excel 2003. The data is from a 14-day set of observations. Not every day has data, and some of the data is from between days, eg. day 13.5. For example, I have data for days 0.5, 1, 4, 7, 11, 12 etc, but not for days 2 or 3. I have no problem making a graph, but the problem is that I cannot make it to scale. For example, I would like days 0.5 and 1 to appear 0.5 arbitrary units apart on the X-axis, and days 1 and 4 to be 3 units apart, to give a visually accurate representation of how the data is changing over time. Plotting them all 1 unit apart regardless of days between does not look good, and does not really represent the data well.

    Can anyone help?

    Cheers,

    Originalsin
     
  2. Originalsin

    Originalsin
    Expand Collapse

    Joined:
    Dec 1, 2000
    479
    0
    Location:
    Australia.
    Right. Found a way. Had to do it as a scatterplot. That seems to work.

    Next thing to figure out is how can I make it so that the data starts at day 7, with day 14 in the middle, and continues to day 7 again... mutter mutter mutter...

    Even if I can modify the labels on the X-axis afterwards, that would work, if there's a way...:impatient::brickwall:
     

  3. Originalsin

    Originalsin
    Expand Collapse

    Joined:
    Dec 1, 2000
    479
    0
    Location:
    Australia.
    Sorted.
     
    #3 Originalsin, Jun 10, 2010
    Last edited: Jun 10, 2010