How to easily change chart element selections in Excel 2016 2019 and Office 365
Selecting chart elements changed in Excel 2016 2019 and Office 365. Learn how to easily change chart element selections with this quick tip.
The...
3 Ways to Make Excel Chart Horizontal Categories Fit Better
Have you ever had a chart where your Horizontal Category Labels overlap each other and they are unreadable?
Check out this chart to see what...
How-to Easily Add Task Information to Excel 2016 Gantt Charts
Easily Add Task Information to Excel 2016 Gantt Charts
Excel 2013 and Excel 2016 make this need so much easier. Thanks Excel! I recently posted...
3 Ways to Add a Target Line to an Excel Pivot Chart
Add a Target Line to an Excel Pivot Chart
Many Excel users use Pivot Tables and they find it very easy to create a Pivot...
Pipeline Usage Chart – Don’s Answer
Here is another response that I received from Don for our recent Friday Challenge:
Friday Pipeline Usage Challenge
Since we weren’t sure from the client if...
How-to Make a Wall Street Journal (WSJ) Double Lollipop Chart in Excel
In our last Friday Challenge, I proposed making a Double Lollipop Chart seen in the Wall Street Journal (WSJ).
Here is what our final chart...
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...
The Tricks to Writing a Conditional Formatting Rule Formula
When you build your Excel Dashboard, you will frequently want to use Conditional Formatting to create color callouts and other table based dashboard components. ...
Using the Camera Tool to Create a Vertical Line Chart in Excel
Last week a user in the Mr. Excel Forum wanted to know how to make a vertical line chart where the horizontal categories are...
How-to Create a Time Data Series Step Chart in Excel
In our recent Friday challenge, we were asked by Anna how can we make our popular Excel Step Chart work for data that is...