Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel training courses uk - charts

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses uk - Charts

excel training courses uk - Charts

ResolvedVersion Standard

Silvia has attended:
Excel Introduction course
Excel Intermediate course

Charts

how do you change the axis range?

RE: Charts

Dear Silvia

It was a pleasure having you in the Excel Intro class today.

Although we do cover this in Intermediate training session but following are teh steps you have to take:

Once the chart has been created

Double-click on the value axis ( most probably in a cloumn chart it will be the Y (vertical) axis.
Click on the Scale tab
choose the maximum or minimum value that you would like and that should change the range of the chart!!

Hope this helps and is clear!!

Excel tip:

Display developer tab - Excel 2010

a. In Excel, click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the box next to Developer in the list of tabs on the right hand side of the dialog box. When ticked the Developer tab will be visible.
e. Click OK to apply your changes

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.