You can change the chart type of many types of charts while viewing data in the chart. Right-click an element in a chart, a bar in a bar graph for example, and choose Chart Type.
Select from the available choices. The choices vary based on the type of data you are using. For example, you may see Area, Bar, Curve, Dot Plot, or Line.
To set the chart type
- From the Toolbox, select Workbooks, then select a workbook and worksheet.
- Select the Design workspace icon if needed.
- Right-click an element in a chart such as a line in a graph and choose Chart Type.
- Choose one of the listed options.