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).?MIS1300MOD45char

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