Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Forcing 'XValues' to the bottom
I have a line chart with positive and negative numbers as 'Values'. My x-axis
legend (the 'XValues') appears in the middle of the screen - along the x axis. I want it to appear at the bottom. Any suggestions? |
#2
|
|||
|
|||
Hi jeff,
Double click the x axis and on the Patterns Tab select Tick mark labels: Low. Cheers Andy jeff wrote: I have a line chart with positive and negative numbers as 'Values'. My x-axis legend (the 'XValues') appears in the middle of the screen - along the x axis. I want it to appear at the bottom. Any suggestions? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
Go to the FORMAT AXIS menu and change the value for "Value (X) axis crosses
at" to a reasonable value. Do not re-select the check box to the left or it will autoscale again. Have a great day! Barb Reinhardt "jeff" wrote in message ... I have a line chart with positive and negative numbers as 'Values'. My x-axis legend (the 'XValues') appears in the middle of the screen - along the x axis. I want it to appear at the bottom. Any suggestions? |
#4
|
|||
|
|||
Both were great ideas and did the trick. Thanks very much!
"Barb Reinhardt" wrote: Go to the FORMAT AXIS menu and change the value for "Value (X) axis crosses at" to a reasonable value. Do not re-select the check box to the left or it will autoscale again. Have a great day! Barb Reinhardt "jeff" wrote in message ... I have a line chart with positive and negative numbers as 'Values'. My x-axis legend (the 'XValues') appears in the middle of the screen - along the x axis. I want it to appear at the bottom. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Greybar at the bottom of the page | Excel Discussion (Misc queries) | |||
Z Chart i.e. top rolling annual bottom rolling monthly middle cum. | Excel Worksheet Functions | |||
how to paste data from top to bottom to bottom to top | Excel Discussion (Misc queries) | |||
Forcing text onto new line in cell | New Users to Excel | |||
how to print a row on the bottom of every page | Excel Discussion (Misc queries) |