<\/figure>\n\n\n\nYou can move the duplicate chart to another position on the worksheet.<\/p>\n\n\n\n
Shortcut Keys for Moving a Chart<\/h2>\n\n\n\n We can use the arrow keys to move an embedded chart to another location on the worksheet.<\/p>\n\n\n\n
We want to move the following embedded chart to another location on the worksheet using the arrow keys.<\/p>\n\n\n\n <\/figure>\n\n\n\nWe use the steps below:<\/p>\n\n\n\n
\nPress and hold down the Ctrl key and click any edge of the chart. Blue handles appear on the four corners of the chart.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nPress the appropriate navigation key to move the chart in the direction you want. For example, if we want to move the chart to the top of the worksheet, we press and hold down the up arrow and release it when the chart is in the position we want.<\/li>\n<\/ol>\n\n\n\nShortcut Keys to Display a Task Pane<\/h2>\n\n\n\n If we want to display the task pane for a chart element, we select the chart element and press Ctrl + 1<\/strong>.<\/p>\n\n\n\nWe want to display the task pane for the chart title element of the following chart.<\/p>\n\n\n\n <\/figure>\n\n\n\nWe use the steps below:<\/p>\n\n\n\n
\nClick the chart title to select it. Blue handles appear on the four corners of the border around the chart title.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nPress Ctrl + 1<\/strong>. This opens the Format Chart Title<\/strong> task pane.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nShortcut Keys for Copying Formatting from One Chart to Another<\/h2>\n\n\n\n To copy formatting from an embedded chart and paste it into another embedded chart, we use the following steps:<\/p>\n\n\n\n
We use the steps below:<\/p>\n\n\n\n
\nPress and hold down the Ctrl <\/strong>key and click any edge of the chart. Release the Ctrl key. You see blue borders on the corners of the chart.<\/li>\n\n\n\nPress Ctrl + C<\/strong>. This copies the chart.<\/li>\n\n\n\nPress and hold the Ctrl key and click any edge of the chart to which we want to copy the formatting.<\/li>\n\n\n\n Press Ctrl + Alt + V<\/strong>. The Paste Special<\/strong> dialog box appears.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nSelect Formats<\/strong> and click OK.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nWe use the same steps to copy formatting from one chart on a chart sheet to another, except for the first step, where we select the chart by clicking just below the top edge of the chart.<\/p>\n\n\n\n
Shortcut keys for Hiding and Displaying Embedded Charts<\/h2>\n\n\n\n Embedded charts are objects, and therefore they can be hidden or displayed by pressing Ctrl + 6<\/strong>.<\/p>\n\n\n\nConclusion<\/h2>\n\n\n\n In this tutorial, we looked at various shortcut keys for charts in Excel. We hope you found the information useful.<\/p>\n","protected":false},"excerpt":{"rendered":"
Using keyboard shortcuts when working with charts in Excel can save time and effort. The shortcuts are a necessary alternative to using a…<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\n
Shortcut Keys for Excel Charts<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n