How to change the axis of a graph in excel 2010?
I have used the excel for a long time..I never have tried to put a graph in it until my friend told me the advantage of the inserted graph...I put a graph in it..I want to change the axis of the graph ..
Who knows how to change the axis of a graph in excel 2010?
ThanksAsked Oct, 06 2010
You can do line charts. Select your chart and choose Chart, Chart Type from the menu. Choose Column or Line and the last one in the Chart sub-type window.Answered Nov, 07 2010
By default, Microsoft Office Excel determines the minimum and maximum scale values of the vertical (value) axis (axis: A line bordering the chart plot area used as a frame of reference for measurement. The y axis is usually the vertical axis and contains data. The x-axis is usually the horizontal axis and contains categories.), also known as the y axis, when you create a chart. However, you can customize the scale to better meet your needs. When the values that are plotted in the chart cover a very large range, you can also change the value axis to a logarithmic scale, also known as log scale.
To change the scale of other axes in a chart, see Change the scale of the horizontal (category) axis in a chart or Change the scale of the depth (series) axis in a chart.
This displays the Chart Tools, adding the Design, Layout, and Format tabs.
Important The following scaling options are available only when a value axis is selected.
Note When you change the order of the values on the vertical (value) axis from bottom to top, the category labels on the horizontal (category) axis flip from the bottom to the top of the chart. Likewise, when you change the order of the categories from left to right, the value labels flip from the left side to the right side of the chart.
Note A logarithmic scale cannot be used for negative values or zero.
To show a label that describes the units, select the Show display units label on chart check box.
Tip Changing the display unit is useful when the chart values are large numbers that you want to appear shorter and more readable on the axis. For example, you can display chart values ranging from 1,000,000 to 50,000,000 as 1 to 50 on the axis and show a label that indicates that the units are expressed in millions.
Note When you click Maximum axis value, the category labels are moved to the opposite side of the chart.
Double click a number on the Y axis, and then a box will pop up...select the Scale tab and go Set Minumum to 600 or 550 or what ever. you can also change max and lotsa other funky stuff :)Answered Nov, 12 2010
Search for Related Topics
insert axis excel 2010 deleted put cagr graph ppt put stars graph prism putting stars graph prism change degree angle ms excel graph lable put significance graph pad prism bars put secondary axis excel 2010 excel 2010 add break graph axis change x axis prompt obiee change object axis lumion c# excel change major axis excel 2010 change graph increments horizontal axis
Related Unresolved Questions