Graphical Representations
Excel offers a wide range of chart types for displaying data. Many of these are over-elaborate. In particular, 3-D effects can be misleading and should be avoided.
In Excel 2007 to construct a chart for your data:
- Select the range containing your data, including any row or column labels.
- On the main ribbon, click on the Insert tab.
- Under the Charts group of icons, select the chart type required, then the preferred chart subtype.
- Under Chart Tools on the main ribbon, use the Design, Layout and Format tabs to customise the chart.
In earlier versions of Excel, select the data range and then Insert > Chart to invoke the Chart Wizard.