How Do You Change The Chart Type Of An Existing Chart
Right click the existing chart and choose change chart type.
How do you change the chart type of an existing chart. Select the chart template you want to apply. Then click the design tab of the chart tools contextual tab in the ribbon. Notice that excel builds a preview for each type using the data you ve specified in the existing chart.
The change chart type window will open. Just select the chart and click change chart type on the design tab of the ribbon. Step 2 select the bars and press ctrl 1 to open the format data series option.
Either way you ll see the same popping out window of change chart type. In the change chart type dialog box that appears click to select the type of chart to use. Most of the people do not go beyond this step because they don t care about the beauty of the chart.
Excel will open the change chart type window where you can browse and select other chart types. Step 3 in the format data series window choose the fill option click on fill and check the box vary color by point. The first box shows a list of chart type categories and the second box shows the available chart types for each chart type category.
Then click the change chart type button in the type button group. Click the templates tab on the left sidebar. You can either click the chart to enable chart tools in design tab or right click the chart to find the change chart type button.
On the design tab in the type group click change chart type.