Excel Visualization: Plotting Stock Charts, Radar Charts, Treemaps, & Donuts
Microsoft Excel 365 | Intermediate
- 10 videos | 1h 18m 7s
- Includes Assessment
- Earns a Badge
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.
WHAT YOU WILL LEARN
discover the key concepts covered in this coursevisualize 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 chartcreate an Excel Open-High-Low-Close stock chart, also known as a candlestick chart, in order to visualize financial datause a radar chart to visualize the multivariate ordinal data and illustrate the advantages and disadvantages of radar chartsformat 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 categoriescreate a pie chart to display a few categories and the proportions that add up to a whole, then explode specific slices in the pie chartuse 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' categoryuse 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 timesummarize the key concepts covered in this course
IN THIS COURSE
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.Digital badges are yours to keep, forever.
YOU MIGHT ALSO LIKE
PEOPLE WHO VIEWED THIS ALSO VIEWED THESE