View Single Post
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

Rob -

1. I don't know what this means:

"For example the value 3 also represents 76.2 on the x axis."

Do you want a secondary X axis, or do you want a numerical axis where now you just
have categories at arbitrary spacing?

2. Here's how to make lines on a line chart:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Rob Herrmann wrote:

I am trying to graph data where the scale for the x-axis has multiple
values. For example the value 3 also represents 76.2 on the x axis. Is
there a way to show multiple x axis values. Also can I make vertical
lines at certain x values.