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