line graph

[Guest]

I have created a graph with two bars and two lines. However one of the lines
the line begins and ends before the eginning and end of th egraph, is there a
way to extend it?
Also the second line graph I would liek to line up the data points with the
first bar series. is this possible?

Thanks

 

[Jon Peltier]

I have created a graph with two bars and two lines. However one of the lines
the line begins and ends before the eginning and end of th egraph, is there a
way to extend it?

Are the source data ranges misaligned? I can't visualize the problem.

Also the second line graph I would liek to line up the data points with the
first bar series. is this possible?

You mean line up the points with the different columns in a clustered
column configuration? You can fudge it:

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

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