Excel Revenue Visualization Guide
Uploaded by
Dascalu OvidiuExcel Revenue Visualization Guide
Uploaded by
Dascalu OvidiuIf I could have only one chart I would be most interested in the
total revenue and the revenue per product group.
So I calculated, grouped and sorted the data and created a
stacked bar chart with data labels showing both total revenue
and revenue per product group over time.
Here's the result:
Chandoo Inc.
Revenue 2011 in K$
30.6
1.1
3.5
Excel Formula e-book
16.9 Dashboard Tutorials
16.5
PM Templates
1.2 1.3 13.9
13.8 Excel School
25.9 4.4 3.9 2.0 1.1
Total
4.7
4.4
10.7 11.1
7.2 7.9
Jan Feb Mar Apr May
Source data
Excel
Excel PM Dashboard Formula e-
Month School Templates Tutorials book Total
Jan 25.9 3.5 1.1 0.2 30.6
Feb 10.7 4.4 1.2 0.2 16.5
Mar 11.1 3.9 1.3 0.6 16.9
Apr 7.2 4.4 2.0 0.2 13.8
May 7.9 4.7 1.1 0.2 13.9
How do you Visualize Product Sales Data
Visualization Challenge from Chandoo.org
Sum of Quantity Per Unit Revenue
Product Name Jan Feb Mar Apr May Jan
Dashboard Tutorial #1 29 35 34 57 25 37
Excel Formula e-book 16 15 62 24 15 10
Excel School - Dashboards Membership 121 42 50 32 35 177
Excel School - Download Membership 42 25 13 10 11 88
Excel School - Online Membership 12 10 7 2 2 65
PM Templates for Excel [2003] 15 22 16 12 18 30
PM Templates for Excel [2007] 72 106 96 114 115 30
PM Templates for Excel [both] 20 14 14 14 17 45
Total 327 269 292 265 238
How would you visualize above da
Visit Chandoo.org
Per Unit Revenue
Feb Mar Apr May
35 37 36 45
10 10 10 10
186 188 191 192
92 94 97 94
60 66 67 67
30 30 30 30
30 29 29 29
45 44 45 45