For most 2-D charts, you can change the chart type of the whole chart to give the chart a different look, or you can select a different chart type for any single data series, which turns the chart into a combination chart.
For bubble charts and all 3-D charts, you can only change the chart type of the whole chart.
Note:To complete this procedure, you must have an existing chart. For more information about how to create a chart, see Create a chart from start to finish.
-
Do one of the following:
-
To change the chart type of the whole chart, click the chart area or plot area of the chart to display the chart tools.
Tip:You can also right-click the chart area or plot area, click Change Chart Type, and then continue with step 3.
-
To change the chart type of a data series, click that data series.
Note:You can change the chart type of only one data series at a time. To change the chart type of more than one data series in the chart, repeat the steps of this procedure for each data series that you want to change.
This displays the Chart Tools, adding the Design, Layout, and Format tabs.
-
On the Design tab, in the Type group, click Change Chart Type.
-
In the Change Chart Type dialog box, click a chart type that you want to use.
The first box shows a list of chart type categories, and the second box shows the available chart types for each chart type category. For more information about the chart types that you can use, see Available chart types.
Tip:To use a chart type that you previously saved as a template, click Templates, and then click the chart template that you want to use.
Next steps
-
If the size of the chart no longer looks right, you can resize the chart (Chart Tools > Format tab > Size group).
-
To change the layout or style of the chart, see Change the layout or style of a chart.
Let's say you have a clustered column chart type, but for your presentation, you would like to show a pie chart. You can change the type of chart you think would best represent your data at any time.
-
To change the Clustered Column to Pie, select your chart.
-
On the Chart Design tab, click Change Chart Type > Pie > Pie.
Your new chart type will show in your spreadsheet.
FAQs
On the Design tab, in the Type group, click Change Chart Type. In the Change Chart Type dialog box, click a chart type that you want to use. The first box shows a list of chart type categories, and the second box shows the available chart types for each chart type category.
How do you change the chart type of an existing chart in Access? ›
Modify the chart To modify a chart, open the form or report in Design or Layout view, and then select the chart which opens the Chart Settings pane. To switch to a different chart type, select a different chart from the Chart Type property drop-down list.
How do I change data in an existing chart? ›
Right-click your chart, and then choose Select Data. In the Legend Entries (Series) box, click the series you want to change. Click Edit, make your changes, and click OK. Changes you make may break links to the source data on the worksheet.
How do you change the chart style in Excel? ›
On the Design tab, in the Chart Styles group, click the chart style that you want to use. Tip: To see all predefined chart styles, click More . Note: When the Excel window is reduced in size, chart styles will be available in the Chart Quick Styles gallery in the Chart Styles group.
How do you change the chart type of an existing chart in Think Cell? ›
Simply left-click on the chart, then you'll see a blue border around the chart and a toolbar will appear. Toward the bottom of the toolbar, you can select the chart type you'll like to convert to.
How do you change the chart type and edit chart labels? ›
To format data labels, select your chart, and then in the Chart Design tab, click Add Chart Element > Data Labels > More Data Label Options. Click Label Options and under Label Contains, pick the options you want. To make data labels easier to read, you can move them inside the data points or even outside of the chart.
How do I change chart data in sheets? ›
- On your Android phone or tablet, open a spreadsheet in the Google Sheets app.
- Double-tap the chart you want to edit.
- Tap Edit chart.
- Choose from: Type: Change the chart type. Legend: Change the legend location. Titles: Change the chart and axis titles. ...
- When you're done, tap Done .
Can you change the chart type of more than one data series in the chart? ›
To change the chart type of a data series, click that data series. Note: You can change the chart type of only one data series at a time. To change the chart type of more than one data series in the chart, repeat the steps of this procedure for each data series that you want to change.
What are four steps to change the chart type in Excel? ›
Here are the steps:
- Select the chart.
- Click on the CHANGE CHART TYPE command in the ribbon menu.
- Choose COLUMN.
- Click OK.
What is the shortcut key for change chart type in Excel? ›
If you click inside some data, and then press Alt+F1 on your desktop keyboard (or Alt+Fn+F1 on a laptop), Excel will provide a chart and use the default chart type. Usually this is a clustered column chart. But you can change the default if you want.
Move a chart to another worksheet
Click anywhere in the chart. Under Chart Tools, on the Design tab, in the Location group, click Move Chart. Do one of the following: To move the chart to a new worksheet, click New sheet, and then in the New sheet box, type a name for the worksheet.
Can you use the Show me options to change the type of an existing chart to any other type in Tableau? ›
Can you use the "Show Me" options to change the type of an existing chart to any other type? Sometimes. The "Show Me" list is always available, but will only allow certain chart types based on the current data. no Panning and zooming are enabled or disabled together.
How do I fix chart type in Excel? ›
Select any chart. On the Design tab, click Change Chart Type. Select a chart type that you'd prefer being the default, but don't click OK just yet. Look at the top of the All Charts tab, and find the chart icon that's highlighted in gray.