Your browser does not support JavaScript. As a result, the menu mouseovers will not work properly.
University of Wisconsin-Rock County Campus Photos
Admissions & Registration
Search | Sitemap | Contact Us | Home > Admissions & Registration Graphic - Bread crumbs repeater
Graphic - Bread crumbs end capGraphic - Spacer
Graphic - Page Border

Home
Academics
Admissions & Registration
Campus at a Glance
Campus Life & Services
Community Resources
Events & News
Library & Technology
Financial Aid
Quick Links
Contact Us

Continuing Education

Course Schedules

D2L

PRISM

Search

Web E-Mail

Graphic - Text Border Graphic - Text Border Graphic - Text Border
Graphic - Text Border
Graphic - Text Border
Graphic - Text Border
Graphic - Text Border
Graphic - Text Border
Computer Lab Tips and Tricks

Making A Chart

1. To successfully make a chart in Excel, data and labels need to be entered into the spreadsheet before beginning any other step. The left most column should have a text-label for each row. The very top row should have labels for each column - to identify what each row represents.

2.  Next, highlight from the top-left cell to the  bottom right cell (which contains data). If you don't need ALL of your data, you can also individually select each COLUMN needed by holding down the CTRL key and highlighting individual columns needed one-at-a-time.

3.  Then select the menus INSERT > CHART and the CHART WIZARD will appear.

 4.  Select the chart style you want. In the sample, a COLUMN chart is shown. Then press on the PRESS AND HOLD TO VIEW SAMPLE button to see if the chart is delivering what you want for the chart.

5.  If the chart looks close to what s needed, then continue through the rest of the wizard. If not - cancel, re-label data, and re-highlight cells.

Chart Wizard where chart style is choosen
6.  On the third screen - you are given options to add titles and labels - as well as to adjust grid lines. 

7.  On the final dialog - you are asked whether to create as a NEW SHEET, or to create AS OBJECT IN an existing object (spreadsheet). To view the chart full screen - choose AS NEW SHEET. To incorporate the chart into a PowerPoint, Word document, or website - choose AS OBJECT IN - and then right-mouse-click and COPY the chart, and then PASTE it into the other application.

In task wizard you can choose to create a chart as a new sheet or as an object in a document

 Step4 of 4 in Chart Wizard

 

 

Graphic - Text Border
Graphic - Text Border Graphic - Text Border Graphic - Text Border

HOME | ACADEMICS | ADMISSIONS & REGISTRATION | CAMPUS AT A GLANCE | COMMUNITY RESOURCES
LIBRARY & TECHNOLOGY | CAMPUS LIFE & SERVICES | EVENTS & NEWS | TUITION, FEES, & FINANCIAL AID
UW-Rock County • 2909 Kellogg Avenue • Janesville WI  53546 • 608/758-6565 • rckinfo@uwc.edu
© Copyright 2004 University of Wisconsin-Rock County. All rights reserved.
Web presence by Foresite Software.

 

Graphic - Spacer