Q1) Data is distribution of the most popular colors for 2005 model luxury cars made in North America. Design the pie chart and bar graph for data. Be sure the names of categories and percentage are illustrated in your graph.
Highlight all your dataset (except titles), and go to "insert", and then select the one you required in "Charts". For Pie chart, you can add percentage under "Chart layouts" after you make pie chart.
|
Color
|
Percent
|
|
Silver
|
20
|
|
White
|
18
|
|
Black
|
16
|
|
Blue
|
13
|
|
Brown
|
10
|
|
Red
|
7
|
|
Yellow
|
6
|
|
other
|
10
|