Excel Visualization: Plotting Stock Charts, Radar Charts, Treemaps, & Donuts

Microsoft    |    Intermediate
• 10 videos | 1h 18m 7s
• Includes Assessment
Rating 4.6 of 153 users (153)
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 course
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
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
Summarize the key concepts covered in this course

IN THIS COURSE

• 3.  Creating Candlestick Charts in Excel
• 4.  Visualizing Data Using Radar Charts in Excel
• 5.  Formatting and Customizing Radar Charts in Excel
• 6.  Visualizing Hierarchical Data Using Excel Treemaps
• 7.  Visualizing Proportions Using Pie Charts in Excel
• 8.  Using the Pie-of-pie and Bar-of-pie Charts in Excel
• 9.  Visualizing Proportions Using Doughnut Charts in Excel
• 10.  Course Summary

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

Rating 4.0 of 6 users (6)
Rating 4.5 of 177 users (177)
Rating 4.7 of 3 users (3)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 380 users (380)
Rating 4.5 of 435 users (435)
Rating 4.5 of 159 users (159)