|
How do you make an Excel graph so the X-axis is to scale with the data?
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
__________________
Lo there do I see my father. Lo there do I see my mother and my sisters and my brothers. Lo there do I see the line of my people back to the beginning. Lo they do call to me, they bid me take my place among them. In the halls of Valhalla. Where the brave may live forever.
|
Linear Mode
