Use Excel To Create Categorical Charts, Histogram Charts, KDE Charts, Heatmap Charts, etc.

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

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
Homepage:

https://www.udemy.com/course/xlchartplus/