Spreadsheets
Download
1 / 15

Charts. - PowerPoint PPT Presentation


  • 266 Views
  • Updated On :

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:.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Charts.' - RexAlvis


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Spreadsheets l.jpg

Spreadsheets

Unit 1

Charts


Charts l.jpg
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:


Slide3 l.jpg


Slide4 l.jpg

  • The chart wizard leads you through the stages required to create a chart.

  • You can change the appearance of the chart after it has been created by means of the Chart toolbar.

  • Because the chart is linked to worksheet data, if you change any values that have been used to create the graph the graph is automatically redrawn using the new data.


Create a chart from worksheet data l.jpg
Create a chart from worksheet data create a chart.

  • To create a chart from data in a worksheet:

  • 1. Select the column or row of figures to be used for the chart.

  • Include the heading for the figures if there is one.


Slide6 l.jpg


Slide7 l.jpg

3. Step 1 – Chart type: create a chart.

  • Select the type

  • and form of chart

  • either from the

  • Standard types

  • or Custom types

  • tab.

  • 4. Click the

  • Next button.


Slide8 l.jpg

Step 2 – Chart source: create a chart.

  • Select the range

    of cells that will be

    used for the chart.

  • The correct range

    of cells to be used

    should already be

    set and you should

    see how the chart

    will look.

  • 5. Click the Next button.


Slide9 l.jpg

Step 3 - Chart options: create a chart.

  • Click the Title tab

    if it not selected and

    enter the Chart title,

    Category (X) axis

    and Value(Y) axis.

  • 6. Click the Next button.


Slide10 l.jpg

Step 4 - Chart location: create a chart.

  • You can either choose to have the chart embedded in the worksheet containing the data, or you can have the chart drawn in a new worksheet.

  • 7. Click Finish.



Edit a chart after it has been created l.jpg
Edit a chart after it has been created 4.

  • To edit a chart:

  • 1. Click the right mouse button when the pointer is over the chart.


Slide13 l.jpg

  • 2. Select the chart wizard step required.

  • You can also click on any of the labels on

  • the chart (e.g. legend, title) and use the

  • formatting bar to change the font, font size etc.


Practise creating charts from worksheet data l.jpg
Practise creating charts from worksheet data 4.

  • Visitors to a console games website were asked to vote on the best games console.

  • The website owners wanted to use this information to judge which console they should concentrate their advertising on for the sale of games.


Slide15 l.jpg

  • The results of their survey were as follows: 4.

  • Console Votes

  • Atari 1562

  • Nintendo 3454

  • PlayStation 3122

  • Sega 1897

  • Xbox 1786

  • Others 5341.

  • Create a worksheet using the above data.

  • 2. Use the data in the worksheet to produce a bar chart, a column chart and a pie chart.

  • 3. Experiment with different forms of each of the above types of charts by editing them after you have created them using the chart wizard.

  • 4. Print an example of each type of chart.


ad