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

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

IN THIS COURSE

  • 2m 23s
  • 8m 2s
  • Locked
    3.  Creating Candlestick Charts in Excel
    6m 11s
  • Locked
    4.  Visualizing Data Using Radar Charts in Excel
    10m 42s
  • Locked
    5.  Formatting and Customizing Radar Charts in Excel
    8m 23s
  • Locked
    6.  Visualizing Hierarchical Data Using Excel Treemaps
    10m 34s
  • Locked
    7.  Visualizing Proportions Using Pie Charts in Excel
    11m 28s
  • Locked
    8.  Using the Pie-of-pie and Bar-of-pie Charts in Excel
    9m 56s
  • Locked
    9.  Visualizing Proportions Using Doughnut Charts in Excel
    7m 51s
  • Locked
    10.  Course Summary
    2m 38s

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.5 of 435 users Rating 4.5 of 435 users (435)
Rating 4.7 of 3 users Rating 4.7 of 3 users (3)
Rating 4.5 of 271 users Rating 4.5 of 271 users (271)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 1438 users Rating 4.6 of 1438 users (1438)
Rating 4.6 of 538 users Rating 4.6 of 538 users (538)
Rating 4.6 of 1179 users Rating 4.6 of 1179 users (1179)