Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Experimental Purpose Master the creation and formatting of charts; Understand the basic composition of charts and the role of some options. [ Experimental content and

Experimental Purpose
Master the creation and formatting of charts;
Understand the basic composition of charts and the role of some options.
[Experimental content and steps]
Create a spreadsheet for "Electronic Vehicle Production" as shown in Figure 5-2, complete the following operations and write down the steps:
Figure 5-1 Production of Electronic Vehicles
\table[[Electronic Vehicle Production ((unit: 10000 vehicles)),],[Year,\table[[World Total],[Production]],China,USA,Japan,India,\table[[Other],[countries]]],[2000,5837,207,1279,1014,80,3257],[2002,5899,325,1228,1026,89,3231],[2004,6445,507,1199,1051,151,3537],[2006,6922,728,1126,1148,201,3719],[2008,7057,934,871,1156,222,3874],[2010,7781,1826,776,963,360,3856]]
Create image:
1 Create a bar chart, pie chart, or line chart by selecting any area in the "Electronic Vehicle Production" spreadsheet;
2 Add a data sequence to the chart;
3 Delete icon data series;
4 Adjust the sequence order of data;
5 Add chart titles;
6 Adjust the position of the chart column;
7 Switch chart rows and columns.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Accidental Data Scientist

Authors: Amy Affelt

1st Edition

1573877077, 9781573877077

More Books

Students also viewed these Databases questions

Question

State the uses of job description.

Answered: 1 week ago

Question

Explain in detail the different methods of performance appraisal .

Answered: 1 week ago