Excel is a powerful tool for analyzing and presenting data, and pivot charts are a great way to visualize data in a pivot table. Inserting a pivot chart can be time-consuming if done using the mouse, but luckily there is an Excel keyboard shortcut that can speed up the process. In this blog post, we will discuss how to use the Keyboard Shortcut to Insert Pivot Chart In Excel.
Keyboard Shortcut to Insert Pivot Chart In Excel
To insert a pivot chart in Excel using the shortcut, follow these steps:
- Select any cell in the pivot table that you want to create a pivot chart for.
- Press the Alt key on your keyboard and then press N and C, in that order.
- Release the Alt key, and a dialog box will appear asking you to choose the type of chart you want to create.
- Select the chart type you want to use, and then click OK.
That’s it! You now have a pivot chart inserted into your worksheet.
Here are some points to remember about the Excel keyboard shortcut for inserting a pivot chart:
- The keyboard shortcut for inserting a pivot chart is Alt+N+C for Windows.
- Unfortunately, there is no equivalent keyboard shortcut for Mac, so Mac users will need to use the mouse to insert a pivot chart.
- The keyboard shortcut will work regardless of whether the pivot table is in a separate worksheet or on the same worksheet as the chart.
- If you have multiple pivot tables in your workbook, make sure to select the correct pivot table before using the keyboard shortcut.