Chart
Create Dynamic Excel Chart Conditional Labels and Callouts
Learn this SIMPLE executive dashboard chart trick for conditional labels and callouts so you can QUICKLY identify individual data points.
EXPLORE THE LIBRARY
Tag: Clustered Column Chart
Bar Chart
How-to Create a Stacked and Unstacked Column Chart in Excel
Stacked and Unstacked Column Chart in Excel Excel is awesome because, even when a certain chart type is not a standard option, there may be a way that you can create the type of chart that y
Chart
A Better Format For Excel Chart Secondary Axis Columns Overlap with 3 Series
Facebook Twitter Pinterest WhatsApp Linkedin Learn a better charting format when your Excel Chart Secondary Axis Columns Overlap with 3 data series. The Problem I didn’t love the last chart
Chart
How-to Make an Excel Single Image Goal Chart
Recently, a healthcare company employee contacted me about a chart he wanted to create. The company that he works for is trying to save trees by reducing their usage of paper in copiers and
Challenge
Friday Challenge Answers: Year over Year Chart Comparisons
Thanks for the submissions for the Friday Challenge. You can get the sample data and chart request here: friday-challenge-help-new-to-excel-yoy-comparisons Here are some other submissions: A
Challenge
How-to Visualize 17000 Data Points of Upload and Download Times
In the last Friday Challenge, I presented you with 17,000+ data points representing 2 days of network data usage. With so many data points, it may be best to visualize the data to see what i
Chart
How-to Add Lines in an Excel Clustered Stacked Column Chart
I have posted several Excel chart samples related to Clustered Stacked Column Charts. In case you missed them, you can check them out here: Excel Clustered Stacked Column Chart Tutorials Rec
Bar Chart
How-to Center Excel Clustered Chart Columns Over Horizontal Category Labels
When you have several series in one chart and only one of those series appear per Horizontal Label Category, you probably want to center the labels as the default will appear in their own se
Chart
How-to Graph Three Sets of Data Criteria in an Excel Clustered Column Chart
Here is a very simple solution to a common Excel Charting question when a user wants to graph “Three sets of data criteria on a chart”. Here is the basis of the question at hand: “I’m not su
Challenge
Petes Stumped Chart Challenge Answer – Pivot Chart with Slicers
In the last Friday Challenge, we were going to see if we could help a user create a chart from this data set. They were confused on what type of chart to make and how to do it. To the user