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...
How-to Show Gaps in a Line Chart When Using the Excel NA() Function
In last Friday’s challenge, we had a Excel Analyst that needed to remove outliers from his Excel Line Chart. In essence, he wanted to...
How-to Eliminate Statistical Outliers in an Excel Line Chart
Okay, I posted this Excel Chart Challenge on Friday. How did you do? I am sure your solution is better than mine. This was...
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...
Multi-Column Stacked Chart – How would you do it? – How I did it.
First, I want to say thank you, because you are an Excel fan. Then again, maybe you are an Excel Geek? I know I...
How-to Create a Scroll Bar in Excel to Make Your Dashboard Dynamic
This is part 1 of creating a dynamic Excel dashboard chart using the scroll bar control.
So in the title I said that we would...
How-to Make a Tenant Timeline Excel Dashboard Chart
So last week, I posted this question that I responded to in an Excel forum. I also asked you how you would solve this...
How-to Make Excel Put Years as the Chart Horizontal Axis Categories
I saw this post in a forum yesterday and thought that everyone should know this. Lord knows that I didn’t know this until just...
The Quickest Way to Select an Data Series in an Excel Chart
In a previous post, I showed you how to get around a frustration that many Excel users have when creating an Excel Dashboard chart. ...
How-to Make an United States Flag Excel Chart (Happy 4th of July)
Happy July 4th (United States Independence Day).
I am home and not working too much this holiday, but wanted to send out a post on...
