{"id":12356,"date":"2022-11-25T09:29:06","date_gmt":"2022-11-25T09:29:06","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=12356"},"modified":"2024-03-28T13:49:30","modified_gmt":"2024-03-28T13:49:30","slug":"shortcut-keys-for-excel-charts","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/","title":{"rendered":"Shortcut Keys for Excel Charts"},"content":{"rendered":"\n
Shortcut-Keys-for-Excel-Charts<\/a>Download File<\/a><\/div>\n\n\n\n

Using keyboard shortcuts when working with charts in Excel can save time and effort. The shortcuts are a necessary alternative to using a mouse. This tutorial details various shortcut keys for charts in Excel.<\/p>\n\n\n\n

Shortcut Key for Creating an Embedded Chart<\/h2>\n\n\n\n

To create a default embedded chart on the active worksheet, we select the data source and press Alt + F1<\/strong>.<\/p>\n\n\n\n

To show how this works, we will create an embedded chart based on the following dataset:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

We use the following steps:<\/p>\n\n\n\n

    \n
  1. Select the dataset.<\/li>\n<\/ol>\n\n\n\n
    \"Table,<\/figure>\n\n\n\n
      \n
    1. Press Alt + F1<\/strong>. This creates a default embedded chart in the active worksheet.<\/li>\n<\/ol>\n\n\n\n
      \"Chart,<\/figure>\n\n\n\n

      Shortcut Keys for Creating a Chart on a Chart Sheet<\/h2>\n\n\n\n

      To create a default chart on a chart sheet, we select the data source and press F11<\/strong>.<\/p>\n\n\n\n

      To show how this works, we will create a chart on a chart sheet based on the following dataset:<\/p>\n\n\n\n

      \"Table\n\nDescription<\/figure>\n\n\n\n

      We use the following steps:<\/p>\n\n\n\n

        \n
      1. Select the dataset.<\/li>\n<\/ol>\n\n\n\n
        \"Table,<\/figure>\n\n\n\n
          \n
        1. Press F11<\/strong>. This creates a default chart on a chart sheet.<\/li>\n<\/ol>\n\n\n\n
          \"\"<\/figure>\n\n\n\n

          Shortcut Key for Duplicating an Embedded Chart<\/h2>\n\n\n\n

          To duplicate a chart that is embedded in the active worksheet, we select the chart and press Ctrl + D <\/strong> or Command + D<\/strong> on a Mac.<\/p>\n\n\n\n

          We want to duplicate the following embedded chart.<\/p>\n\n\n\n

          \"Chart,<\/figure>\n\n\n\n

          We use the steps below:<\/p>\n\n\n\n

            \n
          1. Select the chart. Handles appear around the border of the chart.<\/li>\n<\/ol>\n\n\n\n
            \"\"<\/figure>\n\n\n\n
              \n
            1. Press Ctrl + D<\/strong>, or Command + D<\/strong> on a Mac. This creates a duplicate of the chart on top of the chart.<\/li>\n<\/ol>\n\n\n\n
              \"Chart,<\/figure>\n\n\n\n

              You 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

              \"Chart,<\/figure>\n\n\n\n

              We use the steps below:<\/p>\n\n\n\n

                \n
              1. Press 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
                  \n
                1. Press 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\n

                  Shortcut 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\n

                  We want to display the task pane for the chart title element of the following chart.<\/p>\n\n\n\n

                  \"\"<\/figure>\n\n\n\n

                  We use the steps below:<\/p>\n\n\n\n

                    \n
                  1. Click 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
                      \n
                    1. Press Ctrl + 1<\/strong>. This opens the Format Chart Title<\/strong> task pane.<\/li>\n<\/ol>\n\n\n\n
                      \"Graphical<\/figure>\n\n\n\n

                      Shortcut 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

                        \n
                      1. Press 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\n
                      2. Press Ctrl + C<\/strong>. This copies the chart.<\/li>\n\n\n\n
                      3. Press 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
                      4. Press Ctrl + Alt + V<\/strong>. The Paste Special<\/strong> dialog box appears.<\/li>\n<\/ol>\n\n\n\n
                        \"Graphical<\/figure>\n\n\n\n
                          \n
                        1. Select Formats<\/strong> and click OK.<\/li>\n<\/ol>\n\n\n\n
                          \"Graphical<\/figure>\n\n\n\n

                          We 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\n

                          Conclusion<\/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":"\nShortcut Keys for Excel Charts<\/title>\n<meta name=\"description\" content=\"Learn excel chart keyboard shortcuts to save time and effort while working. This tutorial covers shortcut keys for both embedded and chart sheet charts.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Shortcut Keys for Excel Charts\" \/>\n<meta property=\"og:description\" content=\"Learn excel chart keyboard shortcuts to save time and effort while working. This tutorial covers shortcut keys for both embedded and chart sheet charts.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-25T09:29:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-28T13:49:30+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/word-image-12356-1.png\" \/>\n<meta name=\"author\" content=\"Christopher Sirali\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Christopher Sirali\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/\"},\"author\":{\"name\":\"Christopher Sirali\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370\"},\"headline\":\"Shortcut Keys for Excel Charts\",\"datePublished\":\"2022-11-25T09:29:06+00:00\",\"dateModified\":\"2024-03-28T13:49:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/\"},\"wordCount\":643,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/word-image-12356-1.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/\",\"name\":\"Shortcut Keys for Excel Charts\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/word-image-12356-1.png\",\"datePublished\":\"2022-11-25T09:29:06+00:00\",\"dateModified\":\"2024-03-28T13:49:30+00:00\",\"description\":\"Learn excel chart keyboard shortcuts to save time and effort while working. This tutorial covers shortcut keys for both embedded and chart sheet charts.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/word-image-12356-1.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/word-image-12356-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Shortcut Keys for Excel Charts\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370\",\"name\":\"Christopher Sirali\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g\",\"caption\":\"Christopher Sirali\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Shortcut Keys for Excel Charts","description":"Learn excel chart keyboard shortcuts to save time and effort while working. This tutorial covers shortcut keys for both embedded and chart sheet charts.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/","og_locale":"en_US","og_type":"article","og_title":"Shortcut Keys for Excel Charts","og_description":"Learn excel chart keyboard shortcuts to save time and effort while working. This tutorial covers shortcut keys for both embedded and chart sheet charts.","og_url":"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/","article_published_time":"2022-11-25T09:29:06+00:00","article_modified_time":"2024-03-28T13:49:30+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/word-image-12356-1.png"}],"author":"Christopher Sirali","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Christopher Sirali","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/"},"author":{"name":"Christopher Sirali","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370"},"headline":"Shortcut Keys for Excel Charts","datePublished":"2022-11-25T09:29:06+00:00","dateModified":"2024-03-28T13:49:30+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/"},"wordCount":643,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/word-image-12356-1.png","keywords":["file","pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/","url":"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/","name":"Shortcut Keys for Excel Charts","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/word-image-12356-1.png","datePublished":"2022-11-25T09:29:06+00:00","dateModified":"2024-03-28T13:49:30+00:00","description":"Learn excel chart keyboard shortcuts to save time and effort while working. This tutorial covers shortcut keys for both embedded and chart sheet charts.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/word-image-12356-1.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/word-image-12356-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/shortcut-keys-for-excel-charts\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Shortcut Keys for Excel Charts"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."},{"@type":"Person","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370","name":"Christopher Sirali","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g","caption":"Christopher Sirali"}}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/12356"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=12356"}],"version-history":[{"count":12,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/12356\/revisions"}],"predecessor-version":[{"id":15399,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/12356\/revisions\/15399"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=12356"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=12356"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=12356"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}