top of page

Five must-know charting shortcuts

The function of Excel, under which data can be presented pictorially using graphs and charts, is the most extraordinary feature. While creating some charts in Excel can be fun at times due to the ease with which they can be formed, a few charts could take a lot of time and effort. Here are five Shortcuts that can be used if you are working on charts and making charts takes a lot of your time.

Five shortcuts to create excel charts quickly
Five must-know charting shortcuts

  • Create a new chart on a new sheet

To create a new chart in Excel, select the data, go to insert, and place the chart. However, a shortcut method to even save you seconds is selecting the data and F11. That's it! You have successfully created a chart in less than a second.

  • Create a new chart on the same sheet

To create a new chart in the same worksheet, select the data and use the shortcut key ALT+F1, which saves you time in selecting the data. Next, go to insert, select the chart type and then place the chart. While making a chart is not that tough, saving time is what we target by using shortcut keys.

  • Changing the chart type

Using the short keys, place a chart either in the same or a new sheet. If you do not like the chart type placed automatically, you can use a different graph with the help of built-in templates. Then, select the chart, go to the Chart design ribbon and change the chart type. And now, you can choose any chart that fits your requirement.

  • Display formatting task pane or dialog box

To edit any item in your chart, say, the color of the bars, Horizontal/ Vertical axis, labels, the width of bars, or anything you need in the formatting task pane. The shortcut key to the formatting task pane or the chart dialog box is, Select the item you want to edit and press CTRL+1, and the task pane will appear on the right side of your screen.

  • Make a Reusable Chart Template

We often come across a few complex charts that need to be created repeatedly every time new data is fed. In such a scenario, you can create a chart once and then save it as a template for further projects. Create a chart, right-click, save it as a template, and provide a name to the chart per your requirements.

Creating graphs and charts is a basic function of Excel. However, using shortcuts to create graphs and charts in Excel can save a lot of time, especially while making complex charts. Try making charts in Excel using the five shortcut keys discussed above, and let us know how they worked for you in the comment section.

1 view0 comments

Related Posts

See All
bottom of page