David Goldstein February 2018 Types of Cascade Charts Build UpDown Change Stacked Horizontal iPhone SE Component Costs This build up cascade allows you to show each component contributes to total cost and its relationship to retail price ID: 732622
Download Presentation The PPT/PDF document "CREATING BETTER CASCADE CHARTS" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
CREATING BETTER CASCADE CHARTS
David Goldstein
February, 2018Slide2
Types of Cascade Charts
Build Up/Down
Change
Stacked
HorizontalSlide3
iPhone SE Component Costs
This build up cascade allows you to show each component contributes to total cost and its relationship to retail price.
Previously launched models with similar or same componentsSlide4
Microsoft Income Statement
Use a build down cascade to walk your audience through the line items on an income statement. Switch bars and series to avoid data restructuring. Slide5
Salesforce Cash Flow
A cascade can also be used to show each item on a Statement of Cash Flows. Positive contributions are colored green and negative are red.
Option 1: coloring bars individuallySlide6
Salesforce Cash Flow
A cascade can also be used to show each item on a Statement of Cash Flows. Positive contributions are colored green and negative are red.
Option 2: positive and negative seriesSlide7
Salesforce Cash Flow
A cascade can also be used to show each item on a Statement of Cash Flows. Positive contributions are colored green and negative are red.
Option 3: conditional formattingSlide8
Market Segments
You can use a build down cascade to go from the total market to an addressable market. Reverse the axis if your data is in build up order. Slide9
Converting Crops to Food
A horizontal cascade is useful when you have many bars and lengthy bar labels. Slide10
Amazon’s Record Quarter
This change cascade highlights the big drivers of revenue change for a quarter. Slide11
Apple’s Revenue Change
Use multiple change cascades to show how product and regions contributed to the revenue change over time. Use color to highlight the biggest drivers.Slide12
Private Equity Deal Analysis
A stacked cascade allows you to show more detail for one or more of the bars in the chart.Slide13
Winter Olympic Event Growth
This is a more complex stacked cascade. Use color to highlight and segment the events added between the two years.Slide14
Resources
Use these resources to learn more about how to use Mekko Graphics to improve your charts. For questions or product feedback, email me at david@mekkographics.com.
Cascade Charts
Blogs &
Support
Videos
Watch a recorded version of the full
training webinar
for step-by-step instructions on how to make each chart type
Watch short
videos
on key chart types, analytical enhancements and productivity boostersUse our Chart of the Week blog for inspirationVisit our Build Your CQ blog for tips and tricks to improve your charting proficiencyUse Ask an Expert from the Mekko Graphics ribbon or on our website if you’re struggling to find the right chart for your dataVisit All About Cascade Charts on our website to learn more about how to use cascade charts in your next presentationDownload our chart gallery with more than 200 chartsTake these charts and modify them for your own use