A. В D F 1Year India India_Percent China China_Percent USA_Percent USA 2010 1234281170 0.085718953 1337705000 0.088686221 309321666 0.087809808 2011 1250288729 0.086830654 1344130000 0.089112181 311556874 0.088444336 2012 1265782790 0.087906693 1350695000 0.089547423 313830990 0.089089909 2013 1280846129 0.088952819 1357380000 0.08999062 315993715 0.08970386 2014 1295604184 0.089977743 1364270000 0.090447409 318301008 0.090358852 2015 1310152403 0.090988095 1371220000 0.090908175 320635163 0.091021468 2016 1324509589 0.09198518 1378665000 0.091401758 322941311 0.091676134 2017 1338658835 0.092967823 1386395000 0.091914236 324985539 0.092256447 2018 1352617328 0.09393722 1392730000 0.09233423 326687501 0.092739598 1 2019 1366417754 0.094895638 1397715000 0.092664722 328239523 0.093180183 2020 1380004000 0.095839182 1402667000 0.092993026 330139000 0.093719404

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN:9780357392676
Author:FREUND, Steven
Publisher:FREUND, Steven
Chapter7: Creating Templates, Importing Data, And Working With Smartart, Images, And Screenshots
Section: Chapter Questions
Problem 7EYK
icon
Related questions
Question

Plot 2 pie charts align horizontally (next to each other horizontally) for India Percent and China Percent with all axis, legend and Title labels using subplot() and explode data for 2015 year for both countries:

a) India Percent

b) China Percent

AutoSave
Off
Population - Read-Only -
Search (Alt+Q)
File
Home
Insert
Draw
Page Layout
Formulas
Data
Review
View
Help
X Cut
Calibri
v 11
v A A
ab wrap Text
General
B Copy
Paste
Conditional Format as
Cell
Insert Delete Format
в I U
E E Merge & Center
$ • % 9 8 98
S Format Painter
Formatting v
Table v Styles
Clipboard
Font
Alignment
Number
Styles
Cells
A1
fx
Year
A
D
E
F
H
1 TYear
India
India_Percent
China
China_Percent
USA
USA_Percent
2
2010
1234281170
0.085718953
1337705000
0.088686221
309321666
0.087809808
3
2011
1250288729
0.086830654
1344130000
0.089112181
311556874
0.088444336
4
2012
1265782790
0.087906693
1350695000
0.089547423
313830990
0.089089909
2013
1280846129
0.088952819
1357380000
0.08999062
315993715
0.08970386
2014
1295604184
0.089977743
1364270000
0.090447409
318301008
0.090358852
7
2015
1310152403
0.090988095
1371220000
0.090908175
320635163
0.091021468
8
2016
1324509589
0.09198518
1378665000
0.091401758
322941311
0.091676134
9
2017
1338658835
0.092967823
1386395000
0.091914236
324985539
0.092256447
10
2018
1352617328
0.09393722
1392730000
0.09233423
326687501
0.092739598
11
2019
1366417754
0.094895638
1397715000
0.092664722
328239523
0.093180183
12
2020
1380004000
0.095839182
1402667000
0.092993026
330139000
0.093719404
13
Transcribed Image Text:AutoSave Off Population - Read-Only - Search (Alt+Q) File Home Insert Draw Page Layout Formulas Data Review View Help X Cut Calibri v 11 v A A ab wrap Text General B Copy Paste Conditional Format as Cell Insert Delete Format в I U E E Merge & Center $ • % 9 8 98 S Format Painter Formatting v Table v Styles Clipboard Font Alignment Number Styles Cells A1 fx Year A D E F H 1 TYear India India_Percent China China_Percent USA USA_Percent 2 2010 1234281170 0.085718953 1337705000 0.088686221 309321666 0.087809808 3 2011 1250288729 0.086830654 1344130000 0.089112181 311556874 0.088444336 4 2012 1265782790 0.087906693 1350695000 0.089547423 313830990 0.089089909 2013 1280846129 0.088952819 1357380000 0.08999062 315993715 0.08970386 2014 1295604184 0.089977743 1364270000 0.090447409 318301008 0.090358852 7 2015 1310152403 0.090988095 1371220000 0.090908175 320635163 0.091021468 8 2016 1324509589 0.09198518 1378665000 0.091401758 322941311 0.091676134 9 2017 1338658835 0.092967823 1386395000 0.091914236 324985539 0.092256447 10 2018 1352617328 0.09393722 1392730000 0.09233423 326687501 0.092739598 11 2019 1366417754 0.094895638 1397715000 0.092664722 328239523 0.093180183 12 2020 1380004000 0.095839182 1402667000 0.092993026 330139000 0.093719404 13
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Public key encryption
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning