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

Earlier you mentioned having two vertical axes, which highly complicates
this effort.

If you have a line chart with two series on the primary axis, you can
connect the pairs at each category by double clicking on either series,
selecting the Options tab, and checking High-Low Lines.

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


wrote:

Thank you for your reply,

Really I want a chart with a line (that connect the four points).
The Jan values are 3 and 26.
...
The Apr values are 9 and 38.

p