Other Links

This is one of the 33 lessons from the
Tutorial on Excel

Lesson 2-6: Excel Charts

Excel is the most user friendly chart creator.

In the example below you select cells A1 to C6 and you click on the chart icon of the toolbar

The "Chart Wizard" dialog window appears. You select "Column" in "Chart Type", you select a "Chart sub-type" and you click on "Finish". You resize the chart and set it where you want it.

Now right click in the white space around the chart. A menu appears. Select "Format chart area/Properties" and check the "Don't move or size with cells".

Now hide row 2 and notice that the chart shows only the data for the rows that are visible (see below). This tip can be useful for making your point in an on screen presentation.

To delete the chart just select it and click on "Delete".

If you choose to create a "Line" chart and some data are missing yet you don't want the lines to be broken. Go to the menu bar "Tools/Option/Charts and select "Interpolated.

This is one of the 33 lessons from the
Tutorial on Excel