Graphs

Resolved · Low Priority · Version 2007

Tue 15 Sep 2009, 16:30 Delegate Mary said...

Mary has attended:
Excel Intermediate course
Excel Advanced course

Graphs

How Creating multi axis(3) charts/graphs

Tue 22 Sep 2009, 16:08 Trainer Simon said...

RE: Graphs

Hi Mary,

Thank you for your question.

Do you mean create a chart with three axis such as month, sales figures and sales person?

If so there are specific chart types that allow you an X, Y and Z axis such as Cone, Pyramid and 3D column charts.

I hope this answers your question.

Regards

Simon

Tue 29 Sep 2009: Automatically marked as resolved.

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

Graphs

Graphs

RE: Graphs

Excel articles

Excel tip:

Stop Formula Returning A "#DIV/0" Error

Training Programs
Professional & Management Development