Link to home
Start Free TrialLog in
Avatar of BLCSwimmer
BLCSwimmer

asked on

excel graph displays primary vertical axis above the zero line on the horizontal axis

I have simple line graph.  the vertical axis is a list of dates and the horizontal axis a list of values.  Several of my staff use this graph and have no problems with it, but on this particular  chart the dates (vertical axis) appear above the zero line.  I'm assuming its got to be something in the formatting the staff member inadvertantly changed but I cannot figure out what she did.

I've attached PDF of the graph Bad-Sample-1.pdf
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Hello,

format the Y axis and check the setting for Horizontal axis crosses at 0.  

cheers, teylyn
ASKER CERTIFIED SOLUTION
Avatar of jppinto
jppinto
Flag of Portugal image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of BLCSwimmer
BLCSwimmer

ASKER

Worked like a charm.

thanks.