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...
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
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...
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
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 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 Data Series in an Excel Chart when they are Un-selectable?
When I first learned to make Excel charts, I was taught to select the chart and then select the data series with my mouse. ...