1300 MIS MOD 4 DB

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