Charts

Resolved · Low Priority · Version Standard

Fri 7 Mar 2008, 15:40 Delegate Mike said...

Mike has attended:
Excel Advanced course

Charts

How do I create a chart?

Sun 9 Mar 2008, 11:16 Trainer Cress said...

RE: Charts

On tools menu go to insert>>chart and select your chart type and click next. Then continue to follow the prompts and click finish and you can then format it in lots of different ways

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

View all Excel hints and tips

Application Training

Training ProgramsProfessional & Management Development

eLearning Solutions

Our Promotions

Our Schedule

Course Formats

Our Clients

Charts

Charts

RE: Charts

Excel articles

Excel tip:

Stop Formula Returning A "#DIV/0" Error

Training Programs
Professional & Management Development