Weekly Computer Tip # 18
16 June 2003

Creating a chart quickly without using the Chart Wizard (Microsoft Excel)

Using Excel you can easily make graphic representations of your worksheet data, which is often a good way to visualise information. To create a chart, you must first enter the data for the chart on the worksheet. Then select that data and use the Chart Wizard to step through the process of choosing the chart type and the various chart options. However,

Did you know ...

you can create a chart quickly without using the Chart Wizard?

Here's how:

1. select the range containing the data that is to appear in the chart
2. press F11

This creates a separate chart sheet, using the default chart type, which you can modify as normal. (Special thanks to Yvonne Creba of the University of Cambridge for this tip.)

Until next week.

PS I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.

Home   Training   Support   Clients   Contact Details   News   Disclaimer