Excel 2010 help

Vox Populi Vox Dei

High Tory
Joined
Mar 6, 2004
Messages
53,761
Reaction score
38,620
Location
Cape Town
Hey All

Just wondering if you can help me out with a problem, by looking at the screenshot below:

PED.png

I basically want the negative values (and I'll have all negative values) to be above, rather than below the line. Anyway to fix it?

Thanks
 
You mean you want them above the 0 x-axis?

Make you source values all positives and then manually change the labels to negatives. Not really sure why you would want to do this as a graph like that wouldn't make sense to me.
 
Yes above the 0. Yeah also doesn't make too much sense to me but the head honcho I think wants it like that. I suppose it looks more appealing when the graph looks normal.
 
Yes above the 0. Yeah also doesn't make too much sense to me but the head honcho I think wants it like that. I suppose it looks more appealing when the graph looks normal.

Sounds like classic head honcho thinking ".....the sales figures show a loss but I can make the graph go up......."
 
Try this.. on the left axis.. right click... format axis .....axis options in left pane... right pane select "values in reverse order"... maybe possible option for you?
 
Top
Sign up to the MyBroadband newsletter
X