/
CREATING BETTER CASCADE CHARTS CREATING BETTER CASCADE CHARTS

CREATING BETTER CASCADE CHARTS - PowerPoint Presentation

tawny-fly
tawny-fly . @tawny-fly
Follow
355 views
Uploaded On 2018-11-22

CREATING BETTER CASCADE CHARTS - PPT Presentation

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

charts cascade change build cascade charts build change show cash chart statement negative positive bars green colored revenue contributions

Share:

Link:

Embed:

Download Presentation from below link

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.


Presentation Transcript

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