Help needed with a line chart

[richpuk1]

Hi all - Ive made a line chart that I cant get looking how I want it.

So far I have whats attached

The data is correct, but I want the graph line to start on the y axis.

Also across the x axis, I need the zero across the bottom to be in line with the y axis.

Hope someone can help,

Thanks

Richard

[Andy Pope]

To get the line to start from the Y axis double click the X axis and on the scale tab uncheck "Value (Y) axis crosses between categories"

To get 0 on the X axis you need to specify the values to use for category labels. Right click chart and pick Data Source.
Select the range A1:A11 as the category labels.

Alternatively create a XY-scatter chart rather than a line chart.

[richpuk1]

All sorted,

Thanks a lot!

Cheers