Change the X Axis units
Hey !
I need to create a graphs for physics. The X axis units must be 0.02 , 0.04 , 0.06 , etc. and not 1,2,3,etc. as they are now.. How can I change this ? thanks :) |
Change the X Axis units
Do you mean the Y axis instead (Value Axis). If so pull up properties for
the value axis and go to the Scale tab. If you do mean the X axis (Category Axis). This is supposed to come from your source data. Check your source data. The problem may also be with the way the numbers are formatted (maybe). Pull up properties for the category axis and go to the number tab and adjust the number format. Hope this helps. Thanks, Bill Horton "Luis Hirschberg" wrote: Hey ! I need to create a graphs for physics. The X axis units must be 0.02 , 0.04 , 0.06 , etc. and not 1,2,3,etc. as they are now.. How can I change this ? thanks :) |
Change the X Axis units
Make an XY chart, which treats both X and Y as numerical data, and use a
range of cells for the X values. You can apply the same formatting (markers and lines) to the series as in a line chart. A line chart treats the data as nonnumerical category labels. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Luis Hirschberg" wrote in message ... Hey ! I need to create a graphs for physics. The X axis units must be 0.02 , 0.04 , 0.06 , etc. and not 1,2,3,etc. as they are now.. How can I change this ? thanks :) |
Change the X Axis units
To much time not using excel was my problem.
I didn't create the correct that, but i fixed it :) thanks for the help anyway :) "William Horton" wrote: Do you mean the Y axis instead (Value Axis). If so pull up properties for the value axis and go to the Scale tab. If you do mean the X axis (Category Axis). This is supposed to come from your source data. Check your source data. The problem may also be with the way the numbers are formatted (maybe). Pull up properties for the category axis and go to the number tab and adjust the number format. Hope this helps. Thanks, Bill Horton "Luis Hirschberg" wrote: Hey ! I need to create a graphs for physics. The X axis units must be 0.02 , 0.04 , 0.06 , etc. and not 1,2,3,etc. as they are now.. How can I change this ? thanks :) |
All times are GMT +1. The time now is 05:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com