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

training in excel - chart

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training in excel - Chart

training in excel - Chart

ResolvedVersion Standard

Naomi has attended:
PowerPoint Intermediate Advanced course
Excel Intermediate course

Chart

How to formulate a chart?

RE: chart

Hi Naomi

To create a chart:-

1. Highlight the data to appear on the chart.

2. On the Standard toolbar click the Chart button

3. On the Chart dialog box:

Step 1 - Select the chart to run

Step 2 - Select how the data is to appear

Step 3 - Label the chart

Step 4 - Create the chart as New Sheet or an object on the Current sheet

4. Click OK

The chart is completed

Hope this helps.

Regards

Carlos

Excel tip:

Adding up time greater than 24 hours

When you add up time if it exceeds 24 hours i.e 27 hours appears as 03:00. Go to Format / Cells / Number / Custom. The format is hh:mm but if change it to [hh]:mm it will add up to the correct amount of hours.

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.