by Kevin Lee
Excel archive accomplish it easier for you to accept business abstracts and relationships by announcement advice in a graphical format. Like abounding graphs, a blueprint may accommodate a vertical or accumbent arbor that contains values. Excel sets these ethics back you actualize a chart, but you are chargeless to acclimatize the intervals amid these ethics as able-bodied as the minimum and best ethics of the axis
Launch Excel and accessible a worksheet that has a blueprint whose beat mark intervals you’d like to change. Bang the blueprint to affectation the Blueprint Tools area and again bang the “Format” tab.
Click the arrow aing to the Blueprint Elements drop-down box to appearance a account of blueprint elements. Bang “Horizontal (Value) Axis” if you’d like to change the accumbent axis’s intervals. Otherwise, bang “Vertical (Category) Axis” to change the vertical axis’s intervals. Back you bang one of those choices, Excel draws an outline about the arbor you selected.
Click “Format” alternative to accessible the Architecture Arbor window and again bang “Axis Options.” The window’s Minimum and Best argument boxes appearance the axis’ minimum and best values.
Find the Major Unit argument box and agenda its value. That amount determines the axis’ accepted beat mark interval. For instance, if
14 Things Your Boss Needs To Know About Change Chart Type In Excel | Change Chart Type In Excel – change chart type in excel
| Allowed to be able to my personal website, in this time I’m going to show you concerning change chart type in excel