๐๐๐ฒ๐ฟ๐ ๐๐
๐ฐ๐ฒ๐น ๐๐ต๐ฎ๐ฟ๐, ๐ฎ๐ป๐ฑ ๐ช๐ต๐ฒ๐ป ๐๐ผ ๐จ๐๐ฒ ๐ถ๐
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!
Let me know your thoughts in the comments
๐ฃ๐ฆ: ๐๐ฒ๐๐ฒ๐น ๐๐ฝ ๐๐ผ๐๐ฟ ๐ฐ๐ฎ๐ฟ๐ฒ๐ฒ๐ฟ ๐ฎ๐ป๐ฑ ๐ด๐ฒ๐ ๐๐ถ๐ป๐ฎ๐ป๐ฐ๐ฒ & ๐๐ฐ๐ฐ๐ผ๐๐ป๐๐ถ๐ป๐ด ๐๐ถ๐ฝ๐ ๐น๐ถ๐ธ๐ฒ ๐๐ต๐ถ๐ ๐ฑ๐ฒ๐น๐ถ๐๐ฒ๐ฟ๐ฒ๐ฑ ๐ฟ๐ถ๐ด๐ต๐ ๐๐ผ ๐๐ผ๐๐ฟ ๐ถ๐ป๐ฏ๐ผ๐ :
yourcfoguy.com
Let me know your thoughts in the comments
๐ฃ๐ฆ: ๐๐ฒ๐๐ฒ๐น ๐๐ฝ ๐๐ผ๐๐ฟ ๐ฐ๐ฎ๐ฟ๐ฒ๐ฒ๐ฟ ๐ฎ๐ป๐ฑ ๐ด๐ฒ๐ ๐๐ถ๐ป๐ฎ๐ป๐ฐ๐ฒ & ๐๐ฐ๐ฐ๐ผ๐๐ป๐๐ถ๐ป๐ด ๐๐ถ๐ฝ๐ ๐น๐ถ๐ธ๐ฒ ๐๐ต๐ถ๐ ๐ฑ๐ฒ๐น๐ถ๐๐ฒ๐ฟ๐ฒ๐ฑ ๐ฟ๐ถ๐ด๐ต๐ ๐๐ผ ๐๐ผ๐๐ฟ ๐ถ๐ป๐ฏ๐ผ๐ :
yourcfoguy.com
Loading suggestions...