90 likes | 285 Views
Excel 3. charts. Charts. Graphical representation of data contained in a worksheet Types of charts Column – show relationship among categories of data Line – Shows trends over time Pie – shows relationship of part to a whole Scatter – Shows relationship between two categories.
E N D
Excel 3 charts
Charts • Graphical representation of data contained in a worksheet • Types of charts • Column – show relationship among categories of data • Line –Shows trends over time • Pie – shows relationship of part to a whole • Scatter – Shows relationship between two categories
Creating a Chart • Select the data • Be sure to select data in the correct order • Use the control key to select data in non-adjacent ranges • Choose the Insert Tab • Choose chart type
Formatting the chart • Right click on the chart area • Resizing – click sizing handles in corner and drag • Moving – click on the white area of the chart and drag to a new location • Copy – Right click on the chard area > copy
Chart Objects • To change the appearance of anything in a chart • Right click • Double click
Non-Adjacent Cells • Selecting non-adjacent cells • Select the first range • Hold down the control key > select the next range
Stuff to know about charts • Pie charts can only show 1 range • Title – Chart Layout Tab > Chart title • Sub-Title – Double click after the title, press enter and begin typing • Axes • X • Y
More Stuff to know • Gridlines • Lines in chart that can be turned on or off to make the chart easier to read • Legend • A list that identifies colors and patterns within a chart
Excel 3 charts