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...
Friday Challenge: What Charts Would You Make?
This Friday Challenge involves Network Data Usage. You will find over 17,000 data points representing 2 days of network data usage in the linked file.
With...
Fixing Your Excel Chart When the Multi-Level Category Label Option is Missing.
I am so happy to help my fans, and I saw a recent comment on an older posting of mine and I thought I...
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)...
Creating Excel Stacked Column Chart Label Leader Lines/Spines
In my last post, I showed you how to create a Brace/Curly Bracket/Mustache InfoGraphic type grouping in an Excel Stacked Column Chart.
You can check...
How-to Make an Excel Clustered Stacked Column Chart with Different Colors by Stack
In a popular post, I showed you how to easily create a Clustered Stacked Column chart in Excel using Multi-Level Category Axis options.
Here is...
Create Dynamic Excel Chart Conditional Labels and Callouts
Chart Conditional Labels and Callouts
Learn how to make the simple and easy these Excel Chart Label Callouts:
In my most recent article, I described how...
Friday Challenge – Recreate Pete’s Bullet Chart
Our good friend Pete sent me his take on the Recent Bullet Chart posting. I was dumb founded on how he created it. In...
How-to Select Data Series in an Excel Chart when they are Un-selectable?
When I first learned to make Excel charts, I was taught to select the chart and then select the data series with my mouse. ...
Friday Challenge Answers: Year over Year Chart Comparisons
Thanks for the submissions for the Friday Challenge.
You can get the sample data and chart request here: friday-challenge-help-new-to-excel-yoy-comparisons
Here are some other submissions:
A) In the...