Excel Visualization: Plotting Stock Charts Radar Charts Treemaps & Donuts

Data visualization options in Excel are vast. You should choose your visualization type based on the data and what you want to show from it. For example using High-Low-Close and Open-High-Low-Close charts (also called candlestick charts) you can summarize several stock performance aspects. Excel also lets you build radar charts – great for visualizing multivariate ordinal data such as ratings or scores to spot strengths or spikes. In this course youll not only learn how to build and customize the charts mentioned but youll also create treemaps to visualize hierarchical data and pie charts to display parts of a whole. Youll then generate pie-of-pie and bar-of-pie charts both of which use a secondary visualization to complement a pie chart. Finally youll create donut charts to visualize composition using multiple concentric donut rings to represent points in time.