How to Make a Scatter Plot in Excel (2025)

How to Make a Scatter Plot in Excel

Do you have columns of quantitative data in your Excel sheet that only consist of a list of figures? How can you visualize and analyze the relationship between this quantitative data at a glance? Through a scatter plot. Scatter plots are the best when it comes to comparison between two sets of quantitative data. The … Read more

How to Create a Stem and Leaf Plot in Excel?

How to Create a Stem and Leaf Plot in Excel

Before anything, what is a stem and leaf plot? You are likely to not have heard of it before. However, the general idea that first hits your mind upon hearing of a stem and leaf plot is a plot that might have many leaves rooting from a stem. That’s exactly how a stem and leaf … Read more

How to Create a Stacked Waterfall Chart in Excel?

Example of a stacked waterfall chart created in Excel.

We often use a waterfall chart (or bridge chart) to illustrate how an initial value (like a profit) is affected by a series of positive or negative values over time. A regular waterfall chart has three main elements: A stacked waterfall chart has one additional element: the breakdown of the accumulated amount per period. This … Read more

How to Create a Forest Plot in Excel?

Example of what happens once the dot in the chart is configured to have a black color and border.

Also known as the “blobbogram”, a Forest Plot is a graph showing a visual comparison of the scientific or clinical studies conducted on a particular case or study. It is often used in medical and epidemiological fields for the meta-analysis of clinical trial results. What’s great about it is that you can view the outcome … Read more