Axis to scale

  • Thread starter Thread starter JT
  • Start date Start date
J

JT

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
 
Back
Top