Visualizations in Excel
Excel
How to Add Average Line to Bar Chart in Excel
Occasionally you may want to add a line to a bar chart in Excel to represent the average value of the bars.
This tutorial provides...
Excel
How to Plot a Log-Normal Distribution in Excel
This step-by-step tutorial explains how to plot the following log-normal distribution in Excel:
Step 1: Define the X Values
First, let’s define a range of x-values...
Excel
How to Create a Scatterplot Matrix in Excel (With Example)
A scatterplot matrix is a matrix of scatterplots that lets you understand the pairwise relationship between different variables in a dataset.
This tutorial explains how...
Excel
How to Create a Quadrant Chart in Excel (Step-by-Step)
A quadrant chart is a type of chart that allows you to visualize points on a scatter plot in four distinct quadrants.
This tutorial provides...
Excel
How to Create Progress Bars in Excel (Step-by-Step)
This step-by-step tutorial explains how to create the following progress bars in Excel:
Step 1: Enter the Data
First, let’s enter some data that shows the...
Excel
How to Change Axis Scales in Excel Plots (With Examples)
This tutorial provides a step-by-step example of how to change the x-axis and y-axis scales on plots in Excel.
Step 1: Enter the Data
First, let’s...
Excel
Excel: How to Create a Bubble Chart with Labels
This tutorial provides a step-by-step example of how to create the following bubble chart with labels in Excel:
Step 1: Enter the Data
First, let’s enter...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read