Home > Support > Hints and Tips > Tip of the Week

Weekly Computer Tip # 18
16 June 2003

Start each week with a free tip

To subscribe, please type your email address in the box below:

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.

Email this page to a friend

Enter recipient's email address in the box below:

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  

© Roem Ltd. All Rights Reserved
June 2003