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

excel

ResolvedVersion 2003

Jason has attended:
Excel Intermediate course

Excel

How to create a chart

RE: Excel

Hello Jason

Thank you for your question and welcome to the forum.

Here's how to create a chart:

1. Select the data you wish to have represented in the chart.
2. Click the Chart Wizard button (normally to the right of the sort descending button on the standard toolbar).
3. Follow through the four steps for creating your chart (chart type, data source, chart options, chart location).

You can also quickly make a column chart on it's own sheet by selecting the data and pressing the F11 key.

Amanda

Excel tip:

Turn Function tooltips on and off

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

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.