Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi,
I gave a graph with date values on X-Axis & values from -50000 to 300000 on Y-Axis. Currently my data labels on X Axis are seen touching accross the '0'th position of Y axis (i.e. data labels are comming in middle of my graph on 0th position across y axis). I would like to move down the data labels to appear on x axis touching y axis at -50000 point instead of 0th point. Can someone help me here? |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Double-click on the primary axis. In the Format Axis dialog box, go to the
"Scale" tab. In the minimum value input, type in -50,000. -- John Mansfield "Chitra" wrote: Hi, I gave a graph with date values on X-Axis & values from -50000 to 300000 on Y-Axis. Currently my data labels on X Axis are seen touching accross the '0'th position of Y axis (i.e. data labels are comming in middle of my graph on 0th position across y axis). I would like to move down the data labels to appear on x axis touching y axis at -50000 point instead of 0th point. Can someone help me here? |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Double click the X axis, click on the Patterns tab, and choose Low for Tick
Labels. This leaves the axis where it is (at zero) but moves the labels to the bottom of the chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Chitra" wrote in message ... Hi, I gave a graph with date values on X-Axis & values from -50000 to 300000 on Y-Axis. Currently my data labels on X Axis are seen touching accross the '0'th position of Y axis (i.e. data labels are comming in middle of my graph on 0th position across y axis). I would like to move down the data labels to appear on x axis touching y axis at -50000 point instead of 0th point. Can someone help me here? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I reference x-axis or y-axis scale values to a worksheet ce | Excel Discussion (Misc queries) | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel | |||
how to put x axis values in the chart instead of x axis labels | Charts and Charting in Excel | |||
How do I change X-Axis values in a chart with 2 Y-Axis? | Charts and Charting in Excel | |||
Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel |