Visualizations in Excel
Excel
How to Create a Candlestick Chart in Excel (Step-by-Step)
A candlestick chart is a type of financial chart that displays the price movements of securities over time.
The following step-by-step example shows how to...
Excel
How to Add Labels to Scatterplot Points in Excel
Often you may want to add labels to scatterplot points in Excel, such as in the scatterplot below:
Fortunately this is fairly easy to do...
Excel
How to Create a Scatterplot with Multiple Series in Excel
Often you may want to create a scatterplot with multiple series in Excel, similar to the plot below:
Fortunately this is fairly easy to do...
Excel
How to Create a ROC Curve in Excel (Step-by-Step)
Logistic Regression is a statistical method that we use to fit a regression model when the response variable is binary. To assess how well a logistic...
Excel
How to Create an Interaction Plot in Excel
A 2×2 factorial design is used to understand how two independent variables (each with two levels) affect one dependent variable.
A useful way to visualize...
Excel
How to Fit a Polynomial Curve in Excel (Step-by-Step)
You can use the LINEST() function in Excel to fit a polynomial curve with a certain degree.
For example, you can use the following basic...
Excel
How to Plot Multiple Lines in Excel (With Examples)
You can easily plot multiple lines on the same graph in Excel by simply highlighting several rows (or columns) and creating a line plot.
The...
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