If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
-ve values in Y Axis
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
|
|||
|
|||
-ve values in Y Axis
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
|
|||
|
|||
-ve values in Y Axis
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 news 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? |
Thread Tools | |
Display Modes | |
|
|