Quantcast
How-to Add Edges to Excel Area Charts

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...
Excel Dashboard Template Step-by-Step Tutorial and Sample File

Step-by-Step Tutorial: How-to: Make a Company and Industry P/E (Price to Earnings) Line Chart

1
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

1
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...
Non-Offset Chart Tip

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