| 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) | |||
Linear Mode
