laying out axis

B

Bill H.

I have a simple column chart where the y value can be negative and the x
value is date.

What I can't figure out is how to get the dates to display on the x-axis
BELOW whatever the largest negative y value is. I need for the y values
emanating from the zero point to go up for positive value and down for
negative values.

When I turn on the x axis scale, the values (dates) are placed on the xero
line, and thus smack in the middle of the chart.

How to fix?

Thanks.
 
A

Andy Pope

Hi Bill,

Select the xaxis and press CTRL+1 to display the format dialog.
I have a simple column chart where the y value can be negative and the x
value is date.

What I can't figure out is how to get the dates to display on the x-axis
BELOW whatever the largest negative y value is. I need for the y values
emanating from the zero point to go up for positive value and down for
negative values.

When I turn on the x axis scale, the values (dates) are placed on the xero
line, and thus smack in the middle of the chart.

How to fix?

Thanks.
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Top