Making a Graph

  1. Bring up the WWW page with the sales of washi.
  2. Highlight the entire set of data by dragging from the left of the "Quarter Ended" cell until the lower left cell containing "38"
  3. Copy the highlighted area (right clicking will bring up a menu).
  4. Open up an Excel spreadsheet
  5. Paste the data in by clicking in A1 and then pasting.
  6. Change the cells with dashes to zeros
  7. The dates will be wrong. Highlight all of the cells with the dates, and from the 「書式／セル」 menu choose 「文字列」. Then fill in the dates again by hand. (Sorry!)
  8. Highlight from cell B1 (not A1) until the last cell (with "38"). (The graph program will only tolerate one column with labels which is why the 'A' column can't be selected, too.)
  9. Click on the Graph icon in the menu bar.
  10. Select 折れ線 ("broken line graph", the 3rd choice) from the graph type selection panel
  11. Click through the selection frames (次へ）without making any choices.
  12. Copy the resulting graph and paste it into MS Word.

Sample Completed Graph