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.

--

Cheers
Andy

http://www.andypope.info
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top