Charts have X axis at the top?

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

I just tried to create a couple of charts and every one places the X Axis at the top when showing
expenses. That is the numbers display in the lower right quadrant. The worksheet displays expenses
as a negative value and this is what I want... numbers in parens.

Is there a way to show my expenses in the upper right quadrant without affecting the display of
these figures?

Thanks,

Richard
 
Richard,

Negative values go downward from the X axis. If there are no positive
numbers, then the X axis will be at the top.

If you want the Y axis to get more negative as it goes upward, you can do
this: Make your numbers positive (=-A2, copied down, and use this helper
column for the chart). Now select the Y axis, Format Axis - Number, Custom.
Put a - in front of whatever the format code is:

-General
-0.00
 
Try double clicking the Y-Axis. Scale Tab, Click Values in reverse order.

the direction of more negative numbers will be up.

You might want to play with the Patterns Tab, and in the Tic Mark Lables
group, click Low.

Between the Patterns and the Scale Tab, you will have more permutations than
you can keep straight, but one will be what you want.

Stephen Rasey
 
Stephen said:
Try double clicking the Y-Axis. Scale Tab, Click Values in reverse order.

the direction of more negative numbers will be up.

You might want to play with the Patterns Tab, and in the Tic Mark Lables
group, click Low.

Between the Patterns and the Scale Tab, you will have more permutations than
you can keep straight, but one will be what you want.

Stephen Rasey




at the top when showing


worksheet displays expenses


affecting the display of
Click to expand...
Thank you for the help, but is there a way to simply multiply the data series by -1 (to make the
values positive) in the chart formula ...somewhere?

Richard
 
Stephen said:
Try double clicking the Y-Axis. Scale Tab, Click Values in reverse order.

the direction of more negative numbers will be up.

You might want to play with the Patterns Tab, and in the Tic Mark Lables
group, click Low.

Between the Patterns and the Scale Tab, you will have more permutations than
you can keep straight, but one will be what you want.

Stephen Rasey




at the top when showing


worksheet displays expenses


affecting the display of
Click to expand...
Thank you for the help, but is there a way to simply multiply the data series by -1 (to make the
values positive) in the chart formula ...somewhere?

Richard
 
You cannot put any formula or minus sign in the SERIES formula. You would
have to
create another range of cells where you multiply the original values by -1.

Either you plot the minus sign and play with the axis or you use another set
of cells.

Stephen Rasey
Houston
 
Back
Top