๐๐๐ฒ๐ฟ๐ ๐๐
๐ฐ๐ฒ๐น ๐๐ต๐ฎ๐ฟ๐, ๐ฎ๐ป๐ฑ ๐ช๐ต๐ฒ๐ป ๐๐ผ ๐จ๐๐ฒ ๐ถ๐ ๐๐
Charts are one of the most powerful features that Excel offersโฆ
and each one has their own time & place for when you should use them.
Letโs do a walk through of each chart:๐งต
Charts are one of the most powerful features that Excel offersโฆ
and each one has their own time & place for when you should use them.
Letโs do a walk through of each chart:๐งต
๐ญ. ๐Bar charts โ helps you understand trends over time.
โข Bar chart โ single series
โข Stacked bar chart โ multiple series grouped together
โข Clustered bar chart โ multiple series side by side
โข Horizontal โ alternate orientation
โข Bar chart โ single series
โข Stacked bar chart โ multiple series grouped together
โข Clustered bar chart โ multiple series side by side
โข Horizontal โ alternate orientation
๐ฎ. ๐ Line chart โ helps you understand trends over time, with a line
โข Line chart โ can show 1 or multiple series. I like to utilize 2 series when Iโm trying to understand the intersection
โข Area chart โ highlights magnitude of change by shading the bottom
โข Line chart โ can show 1 or multiple series. I like to utilize 2 series when Iโm trying to understand the intersection
โข Area chart โ highlights magnitude of change by shading the bottom
๐ฏ. ๐ก Pie chart โ helps you understand the distribution between multiple categories
โข Pie Chart โ shows the split / distribution between multiple categories
โข Donut โ shows the % completion. This is in essence a hollow pie chart (my favorite for budget vs actuals)
โข Pie Chart โ shows the split / distribution between multiple categories
โข Donut โ shows the % completion. This is in essence a hollow pie chart (my favorite for budget vs actuals)
๐ฐ. Hierarchy charts โ helps you understand the hierarchy of data
โข Treemap โ provides a hierarchal view of data by color and size
โข Sunburst โ provides a hierarchical data in a circular fashion
โข Treemap โ provides a hierarchal view of data by color and size
โข Sunburst โ provides a hierarchical data in a circular fashion
๐ฑ. ๐ข Statistical charts โ provide a visual representation of data distributions, trends, and patterns
โข Histogram โ Shows the underlying frequency distribution
โข Histogram โ Shows the underlying frequency distribution
โข Box & Whisker โ Shows distribution of data into quartiles, highlighting the mean and outliers.
โข Pareto Chart โ displays both the individual and cumulative frequencies
โข Pareto Chart โ displays both the individual and cumulative frequencies
๐ฒ. Waterfall chart โ Helps in understanding the cumulative effect of sequentially introduced positive or negative values
This is especially relevant when showcasing MRR and ARR
This is especially relevant when showcasing MRR and ARR
๐ณ. Scatter charts โ often used to find correlations and patterns in the data
โข Scatter Chart โ displays the relationship between 2 numerical variables
โข Bubble Chart โ variation of the scatter chart, adding a third dimension using the size of the dots.
โข Scatter Chart โ displays the relationship between 2 numerical variables
โข Bubble Chart โ variation of the scatter chart, adding a third dimension using the size of the dots.
๐ด. Combo charts โ allows you to combine data from multiple series
Helpful when you have information across 2 distinct series (like Revenue and Gross Margin)
Helpful when you have information across 2 distinct series (like Revenue and Gross Margin)
๐ต. ๐บ๏ธ Map Charts โ provide a geographical representation of data
๐ญ๐ฌ. PivotCharts โ allows you to control chart data from a PivotTable
And that's a wrap!
If you enjoyed this, consider:
1. Following me @YourCFOGuy
2. Joining my daily Finance & Accounting tips newsletter: yourcfoguy.com
3. RT for others
If you enjoyed this, consider:
1. Following me @YourCFOGuy
2. Joining my daily Finance & Accounting tips newsletter: yourcfoguy.com
3. RT for others
Loading suggestions...