How-to Add Clean Breaks or Cliff Edges to an Excel Area Chart
How-to Add Clean Breaks or Cliff Edges to an Excel Area Chart
A stacked area chart displays an area of points above other data points...
Friday Challenge – Step Chart for an Excel Time Series
I was recently asked for assistance with this request:
Hi Steve,
I am trying to make a hypnogram with data that we collected over the course...
How-to Easily Make a Dynamic PivotTable Pie Chart for the Top X Values
I recently had a request from a fan of the site on how they could make a dynamic pie chart with the Top 5...
How-to Line Up Your Excel Worksheet Embedded Charts
Have you ever created a lot of charts in an Excel Worksheet and drove yourself crazy trying to line the charts up?
Notice how the...
Step-by-Step Tutorial: How-to: Make a Company and Industry P/E (Price to Earnings) Line Chart
In my last post I showed the concepts of making a P/E (Price-to-Earnings) Excel Chart for your Dashboard Template. In this post I will...
Group Column Chart with Lines for Excel Dashboard Presentations
Yesterday a user in the MrExcel.com Forums asked how he could make a Column Chart in Excel and then Group those Columns with a...
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...
How-to Create a Dynamic Excel Chart of Last 3 Months Data Without Offset
Chart of Last 3 Months
If you wanted to create a dynamic Excel chart of last 3 months of your data but didn't know how to...
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...
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...