Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Apr 2003
    Morgantown, Pennsylvania, USA
    Thanked 0 Times in 0 Posts

    Graphing - Variable distance along X axis (Excel 2000-2003)

    Dear Loungers,

    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?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 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.

Posting Permissions

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