excel training courses uk - charts
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

excel training courses uk - Charts

resolvedResolved · Low Priority · Version Standard

replyReply Wed 7 Nov 2007, 16:35Delegate Silvia said...

Silvia has attended:
Excel Introduction course
Excel Intermediate course

Charts

how do you change the axis range?

For upcoming training course dates see: Pricing & availability

replyReply Wed 7 Nov 2007, 22:41Trainer Rajeev said...

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:

Switching Between Spreadsheets

As the Alt+Tab key switches between loaded applications or files, Ctrl+Tab switches between loaded or open Excel files. Hold down the Ctrl key until you have tabbed to the correct spreadsheet.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard