ExcelBanter - make line in chart start at y axis

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - make line in chart start at y axis (https://www.excelbanter.com/charts-charting-excel/24891-make-line-chart-start-y-axis.html)

Tone

make line in chart start at y axis

I have a line in a chart flows along the x axis but start about .5cm from the
y axis and I want it to start from the y axis. eg I----------- not I
--------------

Any suggestions?

Andy Pope

Hi,

On your Line chart double click the category(X) axis to display the
format dialog. On the scale tab uncheck the
'Value (Y) axis crosses between categories' property.

Cheers
Andy

Tone wrote:
I have a line in a chart flows along the x axis but start about .5cm from the
y axis and I want it to start from the y axis. eg I----------- not I
--------------

Any suggestions?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

All times are GMT +1. The time now is 12:57 PM.