You can use the Recommended Charts command on the Insert tab to quickly create a chart that’s right for your data, or you can use other options to create a custom chart.
-
Open your workbook and go to the spreadsheet that contains your data.
-
Drag the handles
-
On your Android tablet, tap Insert.
On your Android phone, tap the Edit icon
-
Tap Recommended to see the charts that Excel recommends for your data.
-
Scroll through the images of recommended chart designs, and tap any chart design to see how your data will look in that format.
Tips:
-
If you don’t see a chart format that you like, tap Chart on the Insert tab to see all the available chart types.
-
-
-
When you select a chart design, the Chart tab appears.
You can use this tab to view and select chart formats organized by type, layouts with legends, color options, and specific chart elements. Additionally, you can tap the Switch option to see alternate views of your data.
-
Tap your chart to see the context menu.
You can cut and paste the chart, copy it to use elsewhere, or delete it. You can also tap the chart and drag it to another location on your spreadsheet.
-
Open your workbook and go to the spreadsheet that contains your data.
-
Drag the handles
-
On your iPad, tap Insert.
On your iPhone, tap the Edit icon
-
Tap Recommended to see the charts that Excel recommends for your data.
-
Scroll through the images of recommended chart designs, and tap any chart design to see how your data will look in that format.
Tips:
-
If you don’t see a chart format that you like, tap Charts on the Insert tab to see all the available chart types.
-
-
-
When you select a chart design, the Chart tab appears.
You can use this tab to view and select other recommended chart formats, chart formats organized by type, layouts with legends, and specific chart elements. Additionally, you can tap the Switch option to see alternate views of your data.
-
Tap your chart to see the context menu.
You can cut and paste the chart, copy it to use elsewhere, or delete it. You can also tap the chart and drag it to another location on your spreadsheet.
-
Open your workbook and go to the spreadsheet that contains your data.
-
Drag the handles
-
On your Windows tablet, tap Insert.
On your Windows phone, tap More
-
To see the charts that Excel recommends for your data, on your Windows tablet, tap Chart and then tap Recommended.
On your Windows phone, tap Recommended.
-
Scroll through the images of recommended chart designs, and tap any chart design to see how your data will look in that format.
Tips:
-
If you don’t see a chart format that you like, tap Chart on the Insert tab to see all the available chart types.
-
-
-
When you select a chart design, the Chart tab appears.
You can use this tab to view and select other recommended chart formats, additional chart formats organized by type, layouts with legends, color options, and specific chart elements. You can enter a size, alternate text, and a description. Additionally, you can tap the Switch option to see different views of your data.
-
Tap your chart to see the context menu.
You can cut and paste the chart, copy it to use elsewhere, or delete it. You can also tap the chart and drag it to another location on your spreadsheet.
