Quantcast

Understanding How-to Make a Step Chart in Excel Using Index and Match Functions

Here is a quick demonstration on the technique that Peter used for his Step Charts: Learn More about the Challenge HERE   To try it yourself as...
Clustered Stacked Column Chart by Month Year

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

Excel Line Charts Using a Date Axis

0
Not sure if you knew this or not, but Excel is amazing! The makers of Microsoft Excel even went so far as to make sure...

How-to Make an Excel Chart Go Up with Negative Values

In a follow-up to my recent Terrible Chart Tuesday, I wanted to show you 2 different techniques that you can use to create a...
Excel Dashboard Friday Chart Challenge

Friday Challenge – Chart This Data in Excel

Chart This Data in Excel Today's challenge is a simple one but has many answers.  You will be presented with a small set of data and I...

How-to Make Dynamic Excel Dashboard Charts Using Tables

1
For almost every Excel Dashboard you will want to make a Chart template Dynamic.  Meaning that as you add new data, the chart updates...

Is it Possible to make this Excel Column Chart?

I saw this seemingly simple question from an Excel user but I spent a long time trying to figure it out without much success. Can...

Better Formulas for Pipeline Matching Stacked Bar Chart Colors to Products without VBA Solution

Hands off to Leonid :) for this awesome solution with much Much BETTER formulas for a recent Friday Challenge. Here was the original Challenge: friday-challenge-pipeline-usage-chart   Here was...
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 Select an Excel Chart Series

How-to Select Data Series in an Excel Chart when they are Un-selectable?

6
When I first learned to make Excel charts, I was taught to select the chart and then select the data series with my mouse. ...
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