Overview/Description
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, you'll not only learn how to build and customize the charts mentioned, but you'll also create treemaps to visualize hierarchical data and pie charts to display parts of a whole. You'll then generate pie-of-pie and bar-of-pie charts, both of which use a secondary visualization to complement a pie chart. Finally, you'll create donut charts to visualize composition using multiple concentric donut rings to represent points in time.
visualize the trend of a stock's performance based on high, low, and close values over a specific period of time using the Excel High-Low-Close stock chart
create an Excel Open-High-Low-Close stock chart, also known as a candlestick chart, in order to visualize financial data
use a radar chart to visualize the multivariate ordinal data and illustrate the advantages and disadvantages of radar charts
format various aspects of a radar chart's appearance, add individual points to it, and create filled radar charts
use the treemap visualization to visualize hierarchical categories
create a pie chart to display a few categories and the proportions that add up to a whole, then explode specific slices in the pie chart
use the pie-of-pie chart type to create one pie chart with an 'other' category and a second pie chart that expands the fields in that 'other' category
use the doughnut chart type to display the proportions of various categories when adding up to a whole, then use it to plot composition at a single instant as well as at different points in time