lkphidden.blogg.se

When you create a chart in an Excel worksheet, a Word document, or a PowerPoint presentation, you have a lot of options.

Your browser can’t show this frame.Excel for Microsoft 365 Word for Microsoft 365 Outlook for Microsoft 365 PowerPoint for Microsoft 365 Excel for Microsoft 365 for Mac Word for Microsoft 365 for Mac Outlook for Microsoft 365 for Mac PowerPoint for Microsoft 365 for Mac Excel 2021 Word 2021 PowerPoint 2021 Excel 2021 for Mac Word 2021 for Mac PowerPoint 2021 for Mac Excel 2019 Word 2019 PowerPoint 2019 Excel 2019 for Mac Word 2019 for Mac PowerPoint 2019 for Mac Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 Excel 2016 for Mac Word 2016 for Mac PowerPoint 2016 for Mac Excel 2013 Word 2013 Outlook 2013 PowerPoint 2013 Excel 2010 Word 2010 Outlook 2010 PowerPoint 2010 Excel 2007 Word 2007 Outlook 2007 PowerPoint 2007 Excel for Mac 2011 Word for Mac 2011 PowerPoint for Mac 2011 Excel Starter 2010 More. To see the steps for creating an Excel chart with a keyboard shortcut, watch this short Excel tutorial video. Select one of the chart types, and a Sub-type, then click Set as Default ChartĪfter you change that setting, when you create new charts with one of the keyboard shortcuts, the new default type will be used.In the Charts group, click the Dialog Launcher button, at the bottom right.On the Excel Ribbon, click the Insert tab.To select a different default chart type: If you usually make a specific type of Excel chart, change the default setting, so it uses your preferred chart type. When you create a chart using the keyboard shortcuts, the default chart type is used. In this screen shot, you can see the chart data, and the new chart was inserted on the same sheet. To insert the chart on the active worksheet, use the Alt + F1 shortcut keys.In the screen shot below, a column chart has been created, on a new chart sheet – Chart1. To insert a new sheet in the workbook, with a chart for the selected data, select the chart data, and then press the F11 key.If you’d rather use the keyboard to insert a chart, here are a couple of shortcut keys that you can use. There are commands that insert specific chart types, such as Column, Line, Pie, Bar, and other types. To create an Excel chart with a specific chart type, and other settings, go to the Insert tab on the Excel Ribbon, and use the chart commands there. See how to insert a chart, and change an Excel setting, so it inserts a specific chart type. Or, for a quicker way, you can create an Excel chart with shortcut keys. To create a chart in Excel, you can select the chart data on the worksheet, then use the Ribbon commands to insert the chart.