1300 MIS MOD 4 DB

 This PDF ( 

https://go.microsoft.com/fwlink/?linkid=2110101

) has 5 suggestions on how to make your use of Excel charts. Create a 6th suggestion on how to use Excel to make charts and walk through the proposed process (it doesn’t need to be as pretty, but it does need to be clear and helpful). 

5 charts you didn’t
think you could
make in Excel

Map
Use a map chart when you
have geographical regions
in your data, like counties,
states, or countries.

Select any cell within your data range:

China
India
United States
Indonesia
Brazil

1,398.

5

1,350.6
329.7
268.1
210.3

Pakistan
Nigeria
Bangladesh
Russia
Mexico

205.6
201.

0

167.0
146.8
126.6

Then select Insert > Charts >
>Maps > Filled Map.
More details

Available only in Office 365
and Office 2019

Waterfall
Show a running total as
values are added or
subtracted.

0

5

10

15

20

25 Select any cell within your data range:

Revenue

Cost of goods

Gross margin

Admin expense

Net income

23

(8)

15

(1)

14

Then select Insert > Charts > Insert
Waterfall, Funnel, Stock, Surface, or
Radar > Waterfall.
More details

Funnel
Show values across
multiple stages in a
process.

Select any cell within your data range:

Prospects

Needs analysis

Price quotes

Negotiations

Closed sales

500

300

150

80

35

Then select Insert > Charts > Insert
Waterfall, Funnel, Stock, Surface, or
Radar > Funnel.
More details

Bubble
Visually emphasize
specific values with
different bubble sizes.

Select any cell within your data range:

Products

5

14

20

Sales

$6

$12

$

60

Share

3%

12%

33%

18 $24 10%

22 $32 42%

Then select Insert > Charts > Insert Scatter
(X,Y) or Bubble Chart > 3-D Bubble.
More details

Combo
Add a secondary axis to
show different values than
the original axis.

Select any cell within your data range:

Jan

Apr

Jul

Oct

Temp

47

59

76

60

Precip

4.8

2.7

0.8

3.4

Then select Insert > Charts > Combo >
Clustered Column – Line on Secondary Axis.
More details

For more information, visit aka.ms/ExcelHelpCenter

https://support.office.com/en-us/article/Create-a-Map-chart-in-Excel-f2cfed55-d622-42cd-8ec9-ec8a358b593b

https://support.office.com/en-us/article/Create-a-waterfall-chart-8de1ece4-ff21-4d37-acd7-546f5527f185

https://support.office.com/en-us/article/Create-a-funnel-chart-ba21bcba-f325-4d9f-93df-97074589a70e

https://support.office.com/en-us/article/Present-your-data-in-a-bubble-chart-424D7BDA-93E8-4983-9B51-C766F3E330D9

https://support.office.com/en-us/article/add-or-remove-a-secondary-axis-in-a-chart-in-excel-91da1e2f-5db1-41e9-8908-e1a2e14dd5a9

• 5 charts you didn’t think you could make in Excel