Quantcast

How-to Make an Excel Project Status Spectrum Chart

Here is the long awaited demonstration of a recent Friday Challenge.   The challenge was to recreate a Project Management Status Chart that I saw on...

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

How-to Draw a Vertical and Horizontal Line that Intersect in an Excel Chart

4
Recently a user in the Mr. Excel Forum a member wanted to know how they could make an Excel Chart where one Metric was...

Add Multiple Percentages Above Column Chart or Stacked Column Chart

0
I recently posted a tutorial on how you can put a percentage at the top of a Stacked Column Chart.  You can see the...
Final Stacked Column Pivot Chart with a Grand Total Line

How-to Add a Grand Total Line on an Excel Stacked Column Pivot Chart

Today I answer a viewer question. "How do I add a cumulative grand total amount as a line above a stacked column pivot chart...

How-to Make a Dynamic Excel Pie Chart with 4 steps in less than 4...

This is an awesome guest post from our great friend Pete.  He came up with this awesome technique to make a dynamic pie chart...
Copy an Excel Chart on Same Worksheet Keeps Same Data Reference Final Copied Charts

How-to Copy a Chart and Change the Data Series Range References

Last week we learned how to copy a chart in Excel quickly and have it reference a new chart data range on the same...
Replace Numbers with Text for Excel Radar Chart Axis Values

Replace Numbers with Text in Excel Radar Chart Axis Values

Replace Numbers with Text in Excel Radar Chart Axis Values This is a cool Excel Trick that I just created based on a user request...

How-To Create an Excel Step Chart Formula Using the Small Function

In our last Friday Challenge, we were investigating Step Charts.  In case you missed it, you can check it out and download the sample...

How-to Make a Tenant Timeline Excel Dashboard Chart

4
So last week, I posted this question that I responded to in an Excel forum.  I also asked you how you would solve this...
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