Results 1 to 2 of 2
2004-08-31, 14:50 #1
- Join Date
- Apr 2003
- Morgantown, Pennsylvania, USA
- Thanked 0 Times in 0 Posts
Graphing - Variable distance along X axis (Excel 2000-2003)
I'm trying to create a line graph in which the X-axis labels are 0, 2, 8, 12, and 24. But here's the twist, rather than having five equally spaced X-axis categories named 0, 2, 8, 12, and 24, I want them to appear along the X-axis at the right distance. So 8 would be four times farther from the 2, and 12 would be 4 distance unites away from 8, and so forth.
I've tried to trick the graph by adding additional lines to the worksheet to get the categories the right distance apart, but then the lines between the points disappear. I've tried trendlines, but I can't get them to only go from point to point.
Is there a way to do create a relatively simple line graph like this?
2004-08-31, 14:58 #2
- Join Date
- Mar 2002
- Thanked 29 Times in 29 Posts
Re: Graphing - Variable distance along X axis (Excel 2000-2003)
What you describe is an XY chart or Scatter chart. In most charts, the x values are treated as categories, i.e. as nothing more than labels, even if the x values are actually numbers. In an XY chart, the x values are treated as numbers. So you only have to change the chart type.