Summary of Gráfico de Pizza e Rosca
The video discusses how to create and use pie charts and donut charts in Excel. The presenter emphasizes using these charts carefully to convey information accurately. Here are the key points covered in the video:
- Use pie charts or donut charts when comparing at most five pieces of information to avoid confusion.
- Consider using column charts for more than five pieces of information.
- Customize the colors and labels of the charts for better interpretation.
- Create a composition of graphs to present information more effectively.
- Use donut charts for proportional comparisons or filling effects.
- Utilize data validation and functions like VLOOKUP to dynamically display information based on user selection.
- Group elements in the chart for better organization and presentation.
Notable Quotes
— 05:02 — « So the first good practice is to use the pie chart or the donut chart when you have a comparison of at most five pieces of information, beyond that it is already too much. »
— 09:01 — « And why did I place this slice further to the right, because the investments I will generate associated graph to distribute this information. »
— 14:57 — « This is the structure that I defined, leaving everyone centralized, I can select the employee. »
— 20:59 — « With analysis and creativity, you can generate other information I didnt have two tables here we generated, I didnt have pending information here we generated is to understand your situation problem and make compositions appropriately legal. »
Category
Art and Creativity