50 likes | 194 Views
Excel: Charts & Graphs. Xander Jackson http://facultyweb.cortland.edu/alexander.jackson. Intro To Charts. What do Charts do? How are they made? N ormalize data S elect data I nsert Chart Choose T ype What type of Chart should I use? Various designs. Normalize data.
E N D
Excel: Charts & Graphs Xander Jackson http://facultyweb.cortland.edu/alexander.jackson
Intro To Charts • What do Charts do? • How are they made? • Normalize data • Select data • Insert Chart • Choose Type • What type of Chart should I use? • Various designs
Normalize data • Excel likes data in neat columns and rows • When selecting for a chart, make data form up into squares • Select the same size blocks
Select Data • As long as the selections are equivalent, Excel can make a chart • Hold CTRL while selecting to get non-consecutive data
Insert Charts & Choose Type • Open SixCharts.xlsx • Make Charts