Advanced Excel Charts
You are working with different types of data in the Excel workbook. Complete the following tasks:
Scatter Plot with Regression Line: Create a Scatter Plot using the data in the 'Scatter plot' sheet. Add a regression line to the pl
equation (the straight line that best fits the data).
Histogram with 8 Bins: Draw a Histogram using the numbers provided in the 'Histogram' sheet. Make sure the histogram has e
(ranges) to display the data.
Waterfall Chart: Create a Waterfall Chart using the data in the 'Waterfall' sheet. This chart helps show the cumulative effect of se
and negative values.
Sparklines for Product Trends: Add Sparklines (mini-charts) to show the sales trends of different types of products in the 'Sparklin
should visually represent the data in a small space.
Marketing expnditure Sales revenue
673 1487
231 1129
593 1372
521 900
245 2034
620 1732 Sales revenue
111 1312 2600
923 2323 2400
2200
2000
1800 f(x) = 0.747750778495806 x + 1170.00752507899
1600
1400
1200
1000
800
600
400
200
0
0 50 100 150 200 250 300 350 400 450 500 550 60
Sales revenue
70.00752507899
50 400 450 500 550 600 650 700 750 800 850 900 950 1000
Numbers
13.9
2.4
This chart isn't available in your version of Excel.
9.1
0.5 Editing this shape or saving this workbook into a different file format will permanently break the chart.
15.1
0.5
3.6
14.5
1.4
13.9
4.3
19.8
6.0
16.1
18.0
3.0
4.7
0.2
0.5
15.6
19.9
0.7
6.5
5.5
3.6
18.0
2.7
1.3
11.5
6.5
19.6
14.5
8.6
6.0
8.6
11.5
12.1
9.1
19.7
12.7
3.3
19.8
15.6
19.9
15.6
7.0
3.0
2.0
7.5
18.4
1.8
0.3
0.9
19.3
19.6
7.0
0.3
10.3
18.8
0.2
2.2
3.0
10.9
8.6
5.5
1.3
2.4
11.5
0.9
13.3
5.1
0.3
3.0
6.0
1.8
15.6
1.0
17.1
3.6
2.7
19.1
0.8
4.3
0.5
4.7
17.1
10.3
10.9
15.1
12.7
18.8
13.9
8.6
3.3
16.7
17.1
4.3
0.3
15.1
4.3
15.1
12.1
13.3
1.8
3.9
19.9
17.1
13.3
2.2
19.8
17.6
19.3
4.3
19.3
7.5
16.7
2.2
0.6
5.1
6.0
11.5
9.7
16.1
16.7
14.5
10.3
17.1
3.6
0.4
10.3
3.3
4.3
0.8
8.0
1.6
3.9
8.0
0.7
14.5
13.9
0.5
0.4
1.0
0.9
16.1
4.3
19.7
3.9
8.6
1.1
3.3
10.9
18.4
2.2
15.6
2.0
18.4
6.5
2.2
10.3
19.8
5.1
17.1
10.9
1.3
5.5
0.9
0.2
15.1
6.5
0.6
10.3
0.9
2.7
16.1
7.5
8.6
7.0
1.8
15.6
0.9
7.5
15.6
3.9
4.3
2.4
12.7
6.0
11.5
11.5
1.3
8.6
6.5
9.1
0.3
3.6
12.7
2.7
1.0
0.8
7.5
19.3
0.3
15.1
0.2
4.3
17.1
6.0
1.1
19.6
15.6
15.6
16.1
0.7
19.6
0.3
0.5
0.6
11.5
19.1
0.4
4.3
3.3
9.1
18.0
0.5
8.0
19.9
0.3
13.3
3.6
9.1
6.0
0.8
0.4
9.1
19.7
break the chart.
Gross Revenue 17932
Cost of goods sold -5651
Gross Profit 12281
Operating expenses -4000
Operating Income or EBITDA 8281
Interest Income 1301
Depreciation -500 This chart isn't available in your version of Excel.
Interest Expense -3000
Profit before Tax 6082 Editing this shape or saving this workbook into a different file format will perm
Tax -1825
Profit after Tax 4257
ifferent file format will permanently break the chart.
Product type 2013 2014 2015 2016 2017 Sparklines
Breads 3570.02 1054.627 1547.985 2174.5028 6911.004
Dairy 2885.577 3735.138 2187.153 1118.544 2748.4224
Soft Drinks 1577.946 703.0848 2085.286 2302.3364 133.16
