How-to Make Longer Legend Color Bars in an Excel Chart Video Tutorial
Most Excel 2D Column Charts have small color boxes in the legend to point you to the right series in the graph. However, this...
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...
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...
How-to Create a Combo Line and Column Pivot Chart
Some Excel users can be confused when it comes to Pivot Tables and Pivot Charts. I recently saw a post asking for this help:
"Please...
The Absolute Quickest Ways to Make a New Chart in an Excel Spreadsheet
When creating my Microsoft Excel Dashboard Templates, I frequently create a chart to see how it would look and I don’t always keep them. ...
3 Ways to Create Vertical Lines in an Excel Line Chart
Sorry I have been swamped on a new project in Australia and Singapore so my posts have been less frequent than I wish. We...
Case Study: Executive Dashboard Chart Creation – Follow-up
The Problem
In a recent post:
“Case Study: Executive Dashboard Chart Creation” (https://www.exceldashboardtemplates.com/?p=1612)
I presented some basic data that you may have in your company that you...
Date and Time Series Issues in Excel Charts
Many users think they are getting an axis error when they say that their column or line charts are showing every date between data...
How-to Easily Create a Stacked Clustered Column Chart in Excel
Create a Stacked Clustered Column Chart in Excel
There is one type of chart that is always requested, however, Excel doesn’t offer this type of...
How-to Make an Excel Chart with 3 Different Column Widths (Bullet Chart Option 2)
In are recent post, I showed you how to create a Bullet Chart in Excel. Pete, then sent me another way to create a...