How-to Create a Dynamic Banding on an Excel Line Chart
This dynamic shading or banding chart is frequently used in science and in Company Dashboards. It allows the user to quickly see if their...
How-to Make a Pass Fail Chart in Excel
Last week, I posed a Friday Challenge that was posted in a Q&A for Excel. Here it is:
*****************************************************************
Plotting a line graph to track build...
Case Study Solution – Mom Needing Help on Science Fair Graphs/Charts
Yesterday I presented a case study on assisting a mom in creating a chart for a science fair.
You can read more about it here:
Case...
How-to Make an Excel Bullet Chart
Executives and managers love to see gauge charts in their Excel Dashboards. However, gauge charts may confuse or mislead the dashboard readers. For instance,...
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...
Soap Story Dashboard
I am traveling about 100% of the time for my current job. So I spend many more nights in a hotel room than my...
Friday Challenge – Create a Percentage (%) and Value Label within 100% Stacked Chart?
First I want to say I am sorry to those waiting to see the dynamic chart scroll bar tutorial. My project launched this week...
How-to Make an Excel Stacked Column Pivot Chart with a Secondary Axis
In this previous post:
Stopping Excel Pivot Chart Columns from Overlapping When Moving Data Series to the Second Axis
I had a fan question - How...
Excel Goal Chart Filling a Bottle of Soda
In a previous post, and one of my favorites, I showed you a unique company goal chart using a beer mug instead of a...
Stop Excel From Overlapping the Columns When Moving a Data Series to the Second...
Don’t worry, Excel is not changing your chart to a Stacked Clustered Column Chart or Stacked Bar Chart when you move a data series...
