Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Mastering and Extending Excel's Charting Abilities

Mastering and Extending Excel's Charting Abilities

Use Excel To Create Categorical Charts, Histogram Charts, KDE Charts, Heatmap Charts, etc.
Created byJohn Su
Last updated 3/2025
English

What you'll learn

  • Use colormaps to automatically color line, bar, area and pie charts
  • Use Excel to create heatmap charts
  • Use Excel to create histogram charts
  • Use Excel to create KDE charts
  • Use Excel to create jitter scatter charts and regular scatter charts

Course content

11 sections106 lectures5h 24m total length
  • Overview4:59

Requirements

  • No need for programming

Description

Use Excel to create categorical charts such as dot chart, line chart, column chart, bar chart, area chart and pie chart.


Use Excel to create histogram charts, KDE charts, binscatter charts, ridge charts, heatmap charts, jitter scatter charts, regular scatter charts, boxplot charts, scatterbar charts, scatterboxplot charts, pair charts etc. Use colormaps to automatically color  line charts, bar charts, horizontal bar charts, area charts and pie charts.


Using xlChart+'s built-in dozens of colormaps, you can quickly render line charts, bar charts, column charts, area charts, and pie charts with simple mouse operations. These charts can be filled with monochrome, gradient colors, patterns, textures, and images. The transparency of the faces can be set.


With the xlChart+ add-in, you can draw monochrome or multicolor histograms based on univariate and bivariate data, as well as color-filled kernel density estimation charts. It is possible to draw bin scatter plots, ridge plots, etc.


Using the xlChart+ add-in, you can create beautiful heat maps that support colormaps, including regular heat maps, circular heat maps, square heat maps, and triangular square heat maps, etc. Data labels can be added.


With the xlChart+ add-in, you can draw various scatter plots, including regular scatter plots, jitter scatter plots, regular scatter plots, scatter bar charts, and scatter box plots, etc.


Using the xlChart+ add-in, you can draw box plots, violin plots, and cloud-rain plots with various effects. QQ plots and PP plots can be drawn, as well as paired plots and overlay bar charts and box plot paired plots.

Who this course is for:

  • Excel users, chart needers