Hi,
Assuming the line is on the secondary axis.
Right click chart and pick Chart Options.
On Axis tab enable secondary x axis.
Double click secondary x axis and on the scale tab uncheck Value (y)
axis crosses between categories.
On the patterns tab set Line and Ticklabels to none.
Cheers
Andy
KrisP wrote:
Hi,
i have a chart with primary and secondary axis (a bar and line format). I
want to make the line span the whole of the chart, stopping at the edges of
the chart not before.
Is there a way of doing this without manually drawin it on? I cant seem to
find a way of making the line any longer.
Thanks....
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info