Treasure4a

Up Charts [Back to Treasure Trail home page]

How is your charting in Excel?

I'd love to print some charts if you can manage to create them and send them to me.

Here is a little tutorial for Excel 2000 if you need help. It will probably be helpful if you print these pages out so you can look at them easily when you are working in Excel.

Tutorial - creating a Chart in Excel 2000

  1. You need a print out of the trade report on South Australia available here. (You will need Adobe Acrobat reader to open it.)
  2. Look for the section headed 'Major South Australian exports, 2002'. You will be using the data from this section.
  3. Open a spreadsheet page.
  4. In the cell A1 type Major Australian exports, 2002.  This will be the heading for our chart.
    In A2 type Commodity
    In B2 type Value (A$m)
    Then type motor vehicles in A3, Wine in A4 and so on.
    Now type the values in B3, B4 etc. but leave the $ signs off.
  5. Now what you have typed in should look like this:
  6. Save your spreadsheet as exports.xls
  7. Now to create the chart: Select the cells A1 to B11. (this is called a range - it is the range A1:B11)
  8. Find the Chart Wizard icon on the tool bar and click on it.
  9. This will activate the Chart Wizard and basically you just follow it through step by step.
    Choose the type of chart that you want
    Follow the Chart Wizard through, just clicking on Next at each step until you get to Step3.
    At Step 3, click on Legend and 'unselect' show legend
    Click on Next and then Finish
  10. Save your spreadsheet.
  11. Here is my chart
  12.  You will find that by right mouse clicking on parts of the chart you can change colours etc.

Using your chart in a Word document

  1. Your chart is really just an image which you can select and copy into a Word document.
  2. If you left mouse click on the border of the chart, you will see some little handles. With the chart selected this way, either use the Edit Copy from the menu, or ctrl-C, or right mouse click and choose copy.
  3. Open a new page in Microsoft Word, and then paste the image. Then save the word page.
  4. You will be unable to change the chart once it is in Word, so make your changes in Excel first and then copy and paste.

Create lots of different charts

  1. Why don't you try out different types of charts and copy them into a word document?
  2. You could create spreadsheets and charts for imports, export destinations, and import sources (the data that you need is all on the South Australia document)
  3. If you send me your Word documents as attachments to emails to sapp2002@senet.com.au , then I can add them to the page you can see here.

Charts