Chart

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

Resolved · Low Priority · Version Standard

Chart

Phillipa has attended:
Excel Intermediate course

by - delegate Phillipa [1 post] (2008 Feb 19 Tue, 16:44) Reply

How do you change the colour on the charts?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 8 Thu	Bloomsbury	2	book now	£215	£215
2007	2009 Jan 8 Thu	Bloomsbury	3	book now	£224	£224
2007	2009 Jan 12 Mon	Bayswater	4	book now	£224	£224
2007	2009 Jan 13 Tue	Bloomsbury	2	book now	£224	£224
2002/XP	2009 Jan 13 Tue	Tooting	0	FULL
2003	2009 Jan 15 Thu	Southwark	1	book now	£215	£215
Full Schedule: See all 136 Excel Intermediate course dates. Bookings currently available until 30th March 2010.

RE: Chart

by - trainer Rich platinum contributer [754 posts] (2008 Feb 23 Sat, 22:14) Reply

Right click on the chart and select format chart area. You can also change the border area

· Fun Things I've Done With Excel
· How to Create Better Excel Spreadsheets: Part Three
· Excel and Inventory Management
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Advanced level training: Microsoft Excel and the Web

Please browse our web site to find out more about
excel vba courses and other Microsoft training courses.

Excel tip:

Checking formulas with multiple operators

When dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right:

B = brackets
E = exponents
D = division
M = multiplication
A = addition
S = subtraction

It should be noted that multiplication and division are considered equal; as are addition and subtraction.

If you would like to check the order in which Excel is performing calculations in a formula, simply click on the cell containing the formula. Then go to Tools - Formula Auditing and select Evaluate Formula.

In the Evaluate Formula dialogue box that appears on your screen, click the Evaluate button to see how Excel calculates the formula result.

View all Excel hints and tips

Rate this page: