There will not be the option to change Bounds and Units if the data is recognized as discreet values by Excel (e.g. Note that in order to adjust the Bounds and Units settings, Excel needs to recognize the data in an axis as a range of values (e.g.
These, along with a couple of other settings in the task pane, determine the scale used to display your chart. In the Format Axis pane in the right, click the Axis Options button, and change the number in the Major box in the Units section. Right click the axis you want to change, select Format Axis from context menu.
Adjust the Bounds and Units settings, as desired. In Excel 2013, you can change the scale of axis in a chart with following steps: 1. The Axis Options in the Format Axis task pane. For example, if you select a data range to plot, Excel will. Frequently those improvements come in the form of semi-automated tasks - common actions that Excel will do with limited intervention. With each new version of Excel, the capabilities of the program grow. (Click on Axis Options and then the Axis Options icon.) (See Figure 2.)įigure 2. How to Change the Intervals on an X-Axis in Excel.
Make sure Axis Options area is expanded. (If there is no Format Axis choice, then you did not right-click on an axis in step 1.) Excel displays the Format Axis task pane at the right side of the screen. Choose Format Axis from the Context menu. The format axis window pops up and by making changes to the style, color and the weight of lines given in the patterns tab, you can change the way the x-axis looks like. The video begins by selecting a chart and right clicking the dates at the bottom of the data points. In Excel 2013 and later versions, the steps are different: This video is about formatting the charts in Excel especially the x and y axes. Adjust the scale settings (top of the dialog box-Minimum, Maximum, etc.) as desired. The Axis Options of the Format Axis dialog box. Make sure Axis Options is clicked at the left of the dialog box. (If there is no Format Axis choice, then you did not right-click on an axis in step 1.) Excel displays the Format Axis dialog box. 
Excel displays a Context menu for the axis. My x-axis data points are 5,12,16,25,50, but i want the axis to be uniform like 0 10 20 30 40 how do i do that pls be kind and.
Right-click on the axis whose scale you want to change. Hi guys I have a problem using excel and im using excel 2003. (The scale automatically chosen by Excel may not represent the entire universe of possibilities you want conveyed in your chart.) You can change the scale used by Excel by following these steps in Excel 2007 or Excel 2010: While Excel can automatically handle many of the mundane tasks associated with turning raw data into a chart, you may still want to change some elements of your chart.įor instance, you may want to change the scale Excel uses along an axis of your chart. 
Excel includes an impressive graphing capability that can turn the dullest data into outstanding charts, complete with all sorts of whiz-bang do-dads to amaze your friends and confound your enemies.
0 kommentar(er)
