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
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,…
Read MoreAre 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…
Read MoreUsing 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…
Read MoreHere’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…
Read MoreI recently picked up a copy of Stephen Few’s outstanding book Information Dashboard Design. First of all…wow! If your reports include any type of chart or graph, you owe it to yourself to pick up a copy of this incredible resource. Stephen developed a graph called a Bullet Graph, and in this post, I’ll walk through…
Read More