Learn to Use Dynamic Charts to Display Results!

Excel Spreadsheets

What is: feature that can also be used in presentations, the dynamic chart is a way to visually demonstrate the data analysis of a worksheet. They can be dynamically updated and offer filtering options that enable the evaluation of subsets of data.

Why do: Spreadsheets made in Excel are very useful for organizing numbers, but sometimes this data is numerous and complex. Using a PivotChart is the ideal solution to ensure an impressive, clear and objective presentation. It is a powerful resource so that the information presented is well understood by those who are watching. Dynamic graphics are a great way to give you a complete picture of the results you've achieved!

Advanced Charting Course in Excel

Learn how to use dynamic charts in your presentation

Some of the features can be used during a presentation to make it more interesting. In the presentation of results are reported planned and achieved numbers, much better data understood when represented by colored parts of a pizza, or in bars of varied sizes. See the image example:


The first step in building your dynamic chart is to put together a spreadsheet in Excel. Enter all the numbers you want to demonstrate in the presentation and select this data:

Then go to the menu Dices and click the submenu Reporting tables and PivotChart. This action will open the window PivotTable and PivotChart Wizard.

Advanced Charting Course in Excel

Learn to Use Dynamic Charts to Display Results! 1

To create your PivotChart, select the "Microsoft Excel Database or List" and "PivotChart Report" options.

Please click Advance. In step two, make sure that the values ​​you selected for plotting match the data you want to display, and then click the Advance.

In the last step, choose where you want to create your chart, a new sheet, or the existing sheet. This step also has an important feature, the Options which allows you to adjust the formatting and data sources.

Learn to Use Dynamic Charts to Display Results! 2

In the results display, where numbers are reached, the best way to put this data is in colored graphics, which make it easier to see the goals and objectives achieved. These are the steps to creating your PivotChart, which helps you to highlight the important information regarding the results achieved. It is the best way to present numbers and enable the board to have a complete view of what is being demonstrated.

Advanced Charting Course in Excel

Use dynamic graphics to give visual meaning to what is being spoken. A dose of creativity helps develop an impressive presentation, where information is well understood and the main issues are well addressed. Use visuals in your favor and ensure a great impression while presenting results!

And you, have any questions about using dynamic graphics? Tell us in the comments section below!

Excel Spreadsheets


  1. Rafael,
    Thanks for the response, I tried to make some changes, but I could not solve it, but I thank you very much for your attention!

    Fabien Telles

  2. Hi Fabien, when you generate a PivotChart, it's attached to your data source, just like your PivotTable, and by changing one or the other, both automatically change equally. This may be affecting the formatting and how the data is displayed in the chart. You may need to decrease the amount or use of filters in this case so that the deformation does not occur.

  3. I made a Dashboard in Excel with PivotTable and data segmentation, generated dynamic charts combined with axis of grouped columns and goal lines, however when performing date filters the graph loses formatting, the row axis automatically switches to column. Thank you for your attention!!

  4. Good Day!

    When creating a column / row dynamic chart and at the same time using data segmentation, removing the filter from the targeting graph loses formatting and the row returns to column, can you guide me how to solve this problem ??

    Fabien Telles


Please, write your comment
Please enter your name