How-to Make a Dynamic Chart Using Offset Formula
In previous posts I have described how to make a Dynamic Chart in Excel for your Dashboard using Tables. This is a very easy...
Friday Challenge Answer – Using Excel Slicers to Create Dynamic Charts
A big thanks to Don for submitting the first response to last week’s Friday Challenge.
You can check out the challenge here:
Friday Challenge – Excel...
Friday Challenge Answers – Cumulative Events Over Time
In our recent Friday Challenge,
Friday Challenge – Creating an Excel Graph of Cumulative Events Over Time
where a user wanted the following:
Creating a graph of...
How-to Easily Hide Zero and Blank Values from an Excel Pie Chart Legend
If you have ever used a Pie Chart in Excel, then you probably ran into this need.
The need to hide Pie Chart Legend entries...
Change Chart from Amount to Percent using a Drop Down List
In case you were wondering, here is my solution to last Friday’s Excel Challenge.
Our challenge was to see if we could solve this question...
Show Only Selected Data Points in an Excel Chart
So last week I posted this question in the challenge:
Here the user story on what we are trying to do:
‘As an Excel user I...
How-to Make an Excel PickList Chart for Multi Years by Month
Here is my response to the recent Friday Challenge on Creating a Chart for Multi Years by Month.
You can read more about the original...
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...
Dynamically Change Excel Bubble Chart Colors
In last week’s Challenge, I posted a question from an Excel User Forum that asked the following:
“I've used Excel 2010 to create a bubble...
Match Product Chart Colors to Excel Spreadsheet Cells – Pete’s VBA Solution
In the recent Friday Challenge: Create Pipeline Usage Chart
A user wanted to create a bar chart where the values had a specific color by...