Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

charting

ResolvedVersion 2003

Jean has attended:
Excel Intermediate course
Excel Advanced course

Charting

How do change between chart types e.g. a bar chart to a pie chart?

RE: Charting

Hi Jean

Thank you for your question and welcome to the forum.

Once you have created a chart, you can change the chart type by clicking near the edge of the chart area, then go to Chart on the menu bar and select Chart Type.

Then select the type of chart you wish to change to, and click OK.

I hope this helps.
Amanda

Excel tip:

DATEDIF function

The DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002.
the formula function is:
=DATEDIF(Your age,Today(),"Y")
Y stands for year

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.