To change the general chart settings, follow these steps:
1.Open the chart settings pane.
2.In the Chart pane, on the Settings tab, you can change the following chart settings:
•Type: Select the chart type.
•Range: Specify the range of data generating the chart.
•Data series: Specify whether to use columns or rows of the selected range as data series.
•Plot area: Include or exclude the first row or column of the selected range from the plot area. If enabled, the data of the first row or column are used to create captions on the chart.

The settings are applied immediately after selection, the chart is rearranged automatically.