Subscribe to get more articles like this oneĭid you find this article helpful? If you would like to receive new articles, join our email list. You can save a lot of time formatting by copying and pasting formats between charts. Select the chart to which you wish to copy the formatting by clicking just inside the page corner.Select the chart with the formatting you want to copy by clicking just inside the page corner.To copy formatting from one chart sheet to another: A dialog box appears.īelow is the Paste Special dialog box that appears: Select the chart to which you wish to copy the formatting by Control-clicking on its edge.Select the chart with the formatting you want to copy by Control-clicking on its edge.To copy formatting from one embedded chart to another: Copy formatting from one chart to another To display the Formatting task pane (2013 and later versions) or dialog box (2010): Display the Formatting task pane or dialog box Use right, left, up and down arrow keys to move the chart.Ĥ.Click or Ctrl-click the edge of the chart.To select and move an embedded chart on a worksheet: Excel creates a chart on a new sheet using the default chart type. To create a new chart on the current sheet (an embedded chart): Excel creates a chart on a new sheet using the default chart type.Ģ. Select the data you want to use to create a chart.Recommended article: Excel Data Entry Tricks and Shortcuts Every User Should Know 1. The following are some useful shortcuts you can use with Excel charts. If you create a lot of charts in Excel, you're probably looking for shortcuts to speed up creation and formatting. Try These Excel Shortcuts to Save Time Creating and Formatting Chartsīy Avantix Learning Team | Updated September 23, 2020Īpplies to: Microsoft® Excel® 2010, 2013, 2016, 2019 and 365 (Windows)

Mac keyboard shortcut for excel bar