Area Graph start on X axis

[JJCA99]

Hello all,

I've searched all over and for some reason I can't figure out how to get my Area chart to start on the Y Axis

I have forecast for 5 years and I want Year 1 data to start on Y axis and cover my table below. Right now data is offset to the middle of the table
This seems like an easy task but I just can't figure it out.


Any help on this is appreciated.

Thanks,
JJ

 

[aRandomHelper]

Try:
Click on the horizontal axis (Year 1,2,3), right click, you should see Format Axis.
Look for the Axis Options category, expand it, and change Axis position to "On tick marks"

 

[JJCA99]

That just puts tick marks I want the Area chart to start on the Y Axis rather than in the middle of year1 like the image I uploaded.

 

[aRandomHelper]

That just puts tick marks

Are you sure you changed the same setting?

If I change to "Between tick marks"

My chart now looks like your screenshot.

 

[JJCA99]

Are you sure you changed the same setting?
View attachment 31327


If I change to "Between tick marks"
View attachment 31328
My chart now looks like your screenshot.
View attachment 31329

I see. Unless there is another way, but because I have a data table below I don't think it will work. :/