Challenge – Chart This Data in Excel – My Answer
A few Fridays ago, I posted this challenge:
Link here: friday-challenge-chart-this-data-in-excel
Where I asked you to send in your sample charts for this data set:
Data and Request
|Courier||Dis (mi)||Pkg (#)||Price ($)||Pkg (#)||Price ($)|
And we wanted to know how you would graph this data in Excel.
Here is how I would chart the data. It is an Excel Column Chart that is using the data from a Pivot Table. So I guess technically it is a Pivot Chart :). You can download this sample chart and play around with the Slicers and Pivot Table below.
Here are a few notes about this chart.
- It has dynamic characteristics because I added Slicers so that the user can choose what to compare/view in the graph.
- It is using Multi Level Category Labels on the X (Horizontal) Axis
- It is a Pivot Chart that is based off of a pivot table
Additional Chart Resources
Here are additional links that will help you learn how to replicate this chart:
Multi-Level Labels for Horizontal Access
Pivot Table Details
As you replicate this chart, here is how your final Pivot Table and Field List will look for your Pivot Chart:
Sample File Download
You can download the free sample file here: Friday-Challenge-Answers-Chart-this-Data-in-Excel.xlsx
Hopefully this will help you create your next Excel Dashboard Chart.