1 / 6

CPSC 203 Introduction to Computers

CPSC 203 Introduction to Computers. Tutorial 03 and 29 By Jie (Jeff) Gao. Excel – Chart Wizard. “Insert Chart” button or “Insert  Chart” menu 4 steps Select chart type Define source data and series Chart options: labels, legend and axes Create chart as: object or sheet.

gizi
Download Presentation

CPSC 203 Introduction to Computers

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CPSC 203Introduction to Computers Tutorial 03 and 29 By Jie (Jeff) Gao

  2. Excel – Chart Wizard • “Insert Chart” button or “Insert  Chart” menu • 4 steps • Select chart type • Define source data and series • Chart options: labels, legend and axes • Create chart as: object or sheet CPSC Tutorials by Jie Gao

  3. Excel – Tricks in Chart Wizard • Select source data range before starting the wizard • Specify the series names and labels by cell references • Make use of the preview CPSC Tutorials by Jie Gao

  4. Excel – Modify Charts • Text elements: Use the format buttons directly • Size and position: Use handles to adjust • Other appearance: Right click and use “Format …” menu • The 4 steps of chart wizard also have corresponding menu items CPSC Tutorials by Jie Gao

  5. Excel – Page Setup • Each worksheet has separate page setups • Paper size, orientation, margin • Header and footer • Show gridlines or not • Print preview CPSC Tutorials by Jie Gao

  6. Assignment 2 – Hand in • File name: UCID_L0x_Txx.xls • Subject: CPSC 203 UCID L0x Txx A2 • UCID is your student ID • L0x is your Lecture section • Txx is your tutorial section • Send UCID_L0x_Txx.xls as attachment from your …@ucalgary.ca e-mail address to me: gaoj@cpsc.ucalgary.ca CPSC Tutorials by Jie Gao

More Related