Excel 2010 help

[Vox Populi Vox Dei]

Hey All

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



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

 

[HavocXphere]

=abs(A1)

removes the negative

 

[DrJohnZoidberg]

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.

 

[Vox Populi Vox Dei]

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.

 

[InvisibleJim]

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......."

 

[krono9]

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?