# Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

# Chart

## Create a Simple Dot Plot in Excel

| May 16, 2023 |

Dot plots contain a series of dots, with each dot representing a single data point. They’re straightforward, easy-to-read charts that help you see trends and find any potential outliers in your samples. Creating a dot plot in Excel can be done in only a few steps which makes them a popular choice for displaying data!…

## Excel Tips from 20 Experts

| February 21, 2023 |

My friend John Michaloudis does an annual survey of Excel MVPs and experts and asks for their best Excel tip. He compiles the tips into an audio podcast along with show notes and related links. This is a great resource and I love sharing it every year. This year, he rounded up tips from: You’ll…

## How to Make an Excel Dynamic Chart & Keep Updates Consistent

| September 20, 2022 |

For the purposes of this discussion, an Excel dynamic chart is a chart that automatically updates itself whenever new data rows are added. The opposite is a static chart, which won’t incorporate any new data rows added to the existing range. To be clear, when Excel creates a chart based on a range of cells,…

## How to Perform a Frequency Distribution in Excel (no formulas)

| September 13, 2022 |

Are you a school administrator who wants to see how student test scores are distributed, or maybe an accountant who needs to analyze trends in spending or accounts receivable? If so, creating a frequency distribution in Excel is one of the easiest ways to do it!  Essentially, frequency distributions come in handy whenever you need…

## Bar Chart Target Markers

| November 14, 2018 |

Using target markers in a bar chart to compare a value (such as actual sales) to a target (such as budget or forecast) provides a clean display. As with anything in Excel, there are several ways to build such a chart. In this post, we’ll walk through a technique that does not require any calculated…

## Dynamic Chart Title with Slicers

| November 7, 2018 |

Here’s the situation. We have created a PivotTable and related PivotChart, and, since we are nice, we have also provided a Slicer so that the user can easily make selections. But, we’d like the report titles to dynamically update based on the selections made. As with anything in Excel, there are multiple ways to accomplish…