Quantcast

Friday Challenge – Part 2 Removing Gaps from a Clustered Column Chart

Okay Excel Fans, in a previous challenge, we had a problem that we solved for a specific data set.  We wanted to remove white...

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...

Excel Clustered Column Chart Conundrum

Many, many, many Excel users post this problem in user forums.  And this one always throws me for a loop and takes me time...

Show or Hide Selected Chart Data Points in Excel with VBA

Okay, for the last challenge, Peter went above and beyond and also submitted a VBA solution to this problem.  Great job Peter! Here is how...

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...

Friday Challenge On Thursday – Only Show Selected Data Points in an Excel Chart

Hi Excel Fans, Today I am posting the Friday Challenge a day early to give you time to try it out. Here the user story on...

Remove Excel Chart Whitespace from Empty or Zero Columns (Part 1)

Hi everyone.  In the last Friday challenge, we had a user post this question about an Excel Column Chart: Chart: Remove whitespace from empty (non-existent)...

Is it Possible to make this Excel Column Chart?

I saw this seemingly simple question from an Excel user but I spent a long time trying to figure it out without much success. Can...

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...

Friday Challenge Submissions: Change Chart from Amount to Percent From a Picklist

I received 2 submissions from the Friday challenge.  Both were awesome in that they are really creative ways to handle the question from the...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link