laying out axis

  • Thread starter Thread starter Bill H.
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

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

Similar Threads

Horizontal axis to the bottom 1
Positioning x axis at bottom of chart with negative values 5
Data labels along below x axis when y axis has negative values 1
X-Axis When Y-Axis has Plus and Minus Values. 4
Formatting 'X' Axis -- 2 fundamental differences 7
Make Y-axis values correspond to x- axis value 1
Position of X axis labels 4
Excel 2007: X-axis labeling 1

Back
Top