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!
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.
To create your PivotChart, select the "Microsoft Excel Database or List" and "PivotChart Report" options.
Clique em 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.
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.
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!