Change Chart Type
Different chart types are better at illustrating different types of data. For example, column chart are great for comparing values, whilst line chart excel at displaying trends over time. If the chart type being used is not best suited to the data it is representing, you can change the chart type.
- select the chart
- Click the Change Chart Type button in the Type group of the Design tab
- The Change Chart Type dialogue box is displayed. Select the chart type you want to use and then select a chart sub-type
- Click Ok