excel training courses uk - Charts

The UK's most regular instructor-led training courses.
Training information: excel training courses uk · Excel training courses · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Charts

Silvia has attended:
Excel Introduction course
Excel Intermediate course

by - delegate Silvia [2 posts] (2007 Nov 7 Wed, 16:35) Reply

how do you change the axis range?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 9 Fri	Bloomsbury	1	book now	£240	£245
2007	2009 Jan 14 Wed	Bloomsbury	5	book now	£235	£245
2002/XP	2009 Jan 14 Wed	Tooting	0	FULL
2003	2009 Jan 16 Fri	Southwark	0	FULL
2007	2009 Jan 21 Wed	Bloomsbury	3	book now	£240	£245
2003	2009 Jan 21 Wed	Southwark	2	book now	£235	£240
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 31st March 2010.

RE: Charts

by - trainer Rajeev gold contributer [480 posts] (2007 Nov 7 Wed, 22:41) Reply

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!!

· Advanced level training: Microsoft Excel and the Web
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Compare Different MS Excel Training Methods
· Microsoft Excel Training Course
· Microsoft Excel's Best Kept Secret

Excel tip:

Concatenating Results of Formulas

To concatenate the results of formulas simply add the "&" after the formula or function closing bracket.

function1(....)&function2(.....)

see example Creating a range of monthly payments as text.

View all Excel hints and tips

Rate this page: