I am very inept with charts overall - - I need to ensure Y axis intersects X axis at zero ... I thought I changed a setting for that, but it didn't change my chart.
Can you please assist? Thanks.
Terri
I am very inept with charts overall - - I need to ensure Y axis intersects X axis at zero ... I thought I changed a setting for that, but it didn't change my chart.
Can you please assist? Thanks.
Terri
Will the X axis always be at the bottom of the plot area? Will it ever be possible for the values on either Y axis to be less than 0?
When you click "X axis crosses at 0" for the secondary Y axis, that setting will apply to where the secondary X axis (even when not displayed) crosses the secondary Y axis. Assuming the two conditions I asked about are true, I think the setting you need is to fix the y axis minimum (for both primary and secondary Y axes) to 0.
Originally Posted by shg
I did that - through format axis - horizontal axis crosses - axis value = 0 .... I set that for both primary and secondary but it didn't change anything. That is what I had tried first. ?
I'm sure I am just doing something wrong here.
I must have mis-typed. I was not referring to setting the "axis crosses at" property. I was referring to setting the axis minimum property (different from the axis crosses at -- should be at the top of the dialog) to 0 (be sure to check the "Fixed" radio button before trying to enter 0). Of course, this only works if my assumption that the values plotted on each axis will never be less than 0.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks