Line Graphs in 2010

[CMIIandExcel]

Hi all

I am using a second y axis on a bar chart in 2010.
Y Axis one shows Bars and represents actual work done.
Y Axis two shows Lines and represents Target of 100 %.
the x axis is dates weekly

It all works fine, but the only problem is on the first and last week the lines start and stop in the middle of the date category (Column).

Is the a way to extend the lines so that they touch each edge of the graph (I.E from one Y axis to the other y axis)

I hope my definition is understandable

Regards

Mike
(New to 2010 and liking it)

 

[RoryA]

You can add a secondary X axis to the chart, format it with no line, tick marks or labels, and set it so the Y axis crosses between categories. Should do what you want, I think.

 

[CMIIandExcel]

Rorya

Thanks for the tip, i will give it a try this afternoon

Regards

Mike