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

Bar Chart Target Markers

By Jeff Lenning | 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…

Read More

Dynamic Chart Title with Slicers

By Jeff Lenning | 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…

Read More

Bullet Graphs in Excel

By Jeff Lenning | October 27, 2014 |

I 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