Spreadsheets l.jpg
1 / 15


Uploaded on:
Category: Animals / Pets
Spreadsheets. Unit 1 Charts. Charts. Once you have entered data on a worksheet you can use the Chart wizard to display the data as a chart. You can choose between many different types of charts, four of which are illustrated below:.
Slide 1

Spreadsheets Unit 1 Charts

Slide 2

Charts Once you have entered information on a worksheet you can utilize the Chart wizard to show the information as a diagram. You can pick between a wide range of sorts of graphs, four of which are shown beneath:

Slide 3

You have control over most parts of diagram development, including the size, outline title , hub titles and legend . These graph components are shown underneath.

Slide 4

The diagram wizard drives you through the stages required to make an outline. You can change the presence of the graph after it has been made by method for the Chart toolbar. Since the outline is connected to worksheet information, in the event that you change any qualities that have been utilized to make the diagram the chart is consequently redrawn utilizing the new information.

Slide 5

Create a diagram from worksheet information To make an outline from information in a worksheet: 1. Select the segment or column of figures to be utilized for the outline. Incorporate the heading for the figures if there is one.

Slide 6

2. Click the Chart wizard catch. The Chart wizard window will show up.

Slide 7

3. Step 1 – Chart sort: Select the sort and type of graph either from the Standard sorts or Custom sorts tab. 4. Click the Next catch.

Slide 8

Step 2 – Chart source: Select the scope of cells that will be utilized for the graph. The right scope of cells to be utilized ought to as of now be set and you ought to perceive how the graph will look. 5. Click the Next catch.

Slide 9

Step 3 - Chart alternatives: Click the Title tab in the event that it not chose and enter the Chart title, Category (X) hub and Value(Y) hub. 6. Click the Next catch.

Slide 10

Step 4 - Chart area: You can either have the outline implanted in the worksheet containing the information, or you can have the diagram attracted another worksheet. 7. Click Finish.

Slide 11

The outline will be shown in the area picked in Step 4.

Slide 12

Edit a graph after it has been made To alter a diagram: 1. Click the right mouse catch when the pointer is over the diagram.

Slide 13

Chart altering choices menu shows up. You will see that there are four alternatives that are the same as steps 1 to 4 of the diagram wizard. 2. Select the outline wizard step required. You can likewise tap on any of the marks on the diagram (e.g. legend, title) and utilize the arranging bar to change the text style, text dimension and so forth

Slide 14

Practise making graphs from worksheet information Visitors to a console diversions site were requested that vote on the best recreations console. The site proprietors needed to utilize this data to judge which console they ought to focus their publicizing on for the offer of diversions.

Slide 15

The aftereffects of their study were as per the following: Console Votes Atari 1562 Nintendo 3454 PlayStation 3122 Sega 1897 Xbox 1786 Others 5341. Make a worksheet utilizing the above information. 2. Utilize the information in the worksheet to create a bar graph, a segment diagram and a pie outline. 3. Try different things with various types of each of the above sorts of graphs by altering them after you have made them utilizing the diagram wizard. 4. Print a case of every sort of diagram.