I am plotting a chart that shows the distance on the x
axis and the altitude on the y axis. I want the x axis to
be the scale but this is complicated because I have the
name places also on the x axis and Excel is just assuming
that all the locations are equi distant apart and they are
not. Any ideas? Thanks.
JT

Create a XY Scatter chart.

Then, to add the labels, create a dummy series with the appropriate x
values and y value set to zero. For this dummy series, add the names
using either the XY Chartlabeler (www.appspro.com) or Chart Tools
(www.j-walk.com). Finally, and if appropriate, hide the default x-axis
labels.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Business solutions leveraging technology
Microsoft Most Valuable Professional (MVP) 2000-2004

In article <1ba301c4270d$fd80a0a0$(E-Mail Removed)>,
(E-Mail Removed) says...
> I am plotting a chart that shows the distance on the x
> axis and the altitude on the y axis. I want the x axis to
> be the scale but this is complicated because I have the
> name places also on the x axis and Excel is just assuming
> that all the locations are equi distant apart and they are
> not. Any ideas? Thanks.
> JT
>