In this section, you will find easy-to-follow tutorials about creating charts in Excel. It also covers simple tips and how-tos about Excel charting.
Excel’s native Sunburst chart is what many people mean when they refer to a multi-level pie chart. Excel has included it since 2016, so you don’t need to hand-build nested …
A bell curve (also called a normal distribution curve) shows how values spread out around an average. Most values sit near the middle, and fewer show up as you move …
A stacked waterfall chart shows how a total moves from a starting value to an ending value, step by step. It also splits each step into the parts that caused …
If you want to see how your numbers are spread out, a histogram makes the pattern easy to spot. It groups values into intervals, called bins, and shows how many …
In Excel, you can create dynamic chart titles that automatically update based on changes in specific cells. The process removes the need to manually adjust the titles whenever your data …
A Sankey diagram, also known as a Sankey chart, visualizes the movement or flow of resources, energy, or data between different points, showing how quantities flow from one set of …
When you insert a chart into a worksheet, Excel places it roughly in the center of the Excel window, close to the source data. However, to enhance readability—especially since many …
A scatter plot or an XY graph is a type of graph used to display and analyze the relationship between two different variables. The horizontal (x-axis) and vertical (y-axis) axes …
Whether creating charts in Excel, it’s important to know how to resize your charts to fit your needs. A chart that’s too small can be hard to read, while one …
Sparklines allow you to place small charts within the cells in a worksheet in Excel. You can have your data in a row and then create a sparkling that shows …
When we create Excel charts, we have to make them more engaging to users. Bubble charts are such attractive chart types to show complex data. When we use different bubble …
Overlaying graphs in Excel can be useful when you want to show different data series on a single graph, making comparisons and correlations more evident. For example, if you have …