excel: graphs & charts
DESCRIPTION
Excel: Graphs & Charts. Explain – what is being said in the following charts. 75. 25. Why Graphs or Charts?. Easy to display data Quickly compare data Quickly see trends in data. Types of Graphs / Charts. 1. Column Chart. Types of Graphs / Charts. 2. Bar Graph. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Excel: Graphs & Charts](https://reader036.vdocuments.us/reader036/viewer/2022062302/568167e5550346895ddd4f74/html5/thumbnails/1.jpg)
Excel: Graphs & Excel: Graphs & ChartsCharts
![Page 2: Excel: Graphs & Charts](https://reader036.vdocuments.us/reader036/viewer/2022062302/568167e5550346895ddd4f74/html5/thumbnails/2.jpg)
Explain – what is being Explain – what is being said in the following said in the following chartscharts
![Page 3: Excel: Graphs & Charts](https://reader036.vdocuments.us/reader036/viewer/2022062302/568167e5550346895ddd4f74/html5/thumbnails/3.jpg)
![Page 4: Excel: Graphs & Charts](https://reader036.vdocuments.us/reader036/viewer/2022062302/568167e5550346895ddd4f74/html5/thumbnails/4.jpg)
![Page 5: Excel: Graphs & Charts](https://reader036.vdocuments.us/reader036/viewer/2022062302/568167e5550346895ddd4f74/html5/thumbnails/5.jpg)
![Page 6: Excel: Graphs & Charts](https://reader036.vdocuments.us/reader036/viewer/2022062302/568167e5550346895ddd4f74/html5/thumbnails/6.jpg)
75
25
![Page 7: Excel: Graphs & Charts](https://reader036.vdocuments.us/reader036/viewer/2022062302/568167e5550346895ddd4f74/html5/thumbnails/7.jpg)
![Page 8: Excel: Graphs & Charts](https://reader036.vdocuments.us/reader036/viewer/2022062302/568167e5550346895ddd4f74/html5/thumbnails/8.jpg)
![Page 9: Excel: Graphs & Charts](https://reader036.vdocuments.us/reader036/viewer/2022062302/568167e5550346895ddd4f74/html5/thumbnails/9.jpg)
Why Graphs or Charts?Why Graphs or Charts?
1.1. Easy to display dataEasy to display data
2.2. Quickly compare Quickly compare datadata
3.3. Quickly see trends Quickly see trends in datain data
![Page 10: Excel: Graphs & Charts](https://reader036.vdocuments.us/reader036/viewer/2022062302/568167e5550346895ddd4f74/html5/thumbnails/10.jpg)
Types of Graphs / Types of Graphs / ChartsCharts1. Column Chart1. Column Chart
![Page 11: Excel: Graphs & Charts](https://reader036.vdocuments.us/reader036/viewer/2022062302/568167e5550346895ddd4f74/html5/thumbnails/11.jpg)
Types of Graphs / Types of Graphs / ChartsCharts2. Bar Graph2. Bar Graph
![Page 12: Excel: Graphs & Charts](https://reader036.vdocuments.us/reader036/viewer/2022062302/568167e5550346895ddd4f74/html5/thumbnails/12.jpg)
Types of Graphs / Types of Graphs / ChartsCharts3. Line Graph3. Line Graph
![Page 13: Excel: Graphs & Charts](https://reader036.vdocuments.us/reader036/viewer/2022062302/568167e5550346895ddd4f74/html5/thumbnails/13.jpg)
Types of Graphs / Types of Graphs / ChartsCharts 4. Pie Chart 4. Pie Chart
Coconut
![Page 14: Excel: Graphs & Charts](https://reader036.vdocuments.us/reader036/viewer/2022062302/568167e5550346895ddd4f74/html5/thumbnails/14.jpg)
Chart Wizard!Chart Wizard! Easy tool used to Easy tool used to
make charts fastmake charts fast A wizard A wizard The chart wizardThe chart wizard
![Page 15: Excel: Graphs & Charts](https://reader036.vdocuments.us/reader036/viewer/2022062302/568167e5550346895ddd4f74/html5/thumbnails/15.jpg)
Step 1 – Chart type Step 1 – Chart type
Highlight the Data Highlight the Data Click on the Chart Click on the Chart
Wizard Wizard Select the Chart Type Select the Chart Type Click Next Click Next
![Page 16: Excel: Graphs & Charts](https://reader036.vdocuments.us/reader036/viewer/2022062302/568167e5550346895ddd4f74/html5/thumbnails/16.jpg)
Step 2 – Chart Data Step 2 – Chart Data SourceSource
Select the correct Select the correct Data PointsData Points
Click on Next Click on Next
![Page 17: Excel: Graphs & Charts](https://reader036.vdocuments.us/reader036/viewer/2022062302/568167e5550346895ddd4f74/html5/thumbnails/17.jpg)
Step 3 – Chart OptionsStep 3 – Chart Options
Format your Chart in Format your Chart in Chart OptionsChart Options
Add Title, name axisAdd Title, name axis Add legendAdd legend Use preview to see Use preview to see
how the chart how the chart changes with changes with formattingformatting
![Page 18: Excel: Graphs & Charts](https://reader036.vdocuments.us/reader036/viewer/2022062302/568167e5550346895ddd4f74/html5/thumbnails/18.jpg)
Step 4 – Chart LocationStep 4 – Chart Location
Specify the Chart Specify the Chart Location – Location – – an object in the an object in the
existing spreadsheet existing spreadsheet
![Page 19: Excel: Graphs & Charts](https://reader036.vdocuments.us/reader036/viewer/2022062302/568167e5550346895ddd4f74/html5/thumbnails/19.jpg)
Step 5 – Fine tune Step 5 – Fine tune formatformat
Go back to activate Go back to activate the Chart Wizard the Chart Wizard again again
Leave information Leave information you like you like
Re-do any of the Re-do any of the steps steps
![Page 20: Excel: Graphs & Charts](https://reader036.vdocuments.us/reader036/viewer/2022062302/568167e5550346895ddd4f74/html5/thumbnails/20.jpg)
Now for the data…. Now for the data…. Vote!Vote! Write a list of Write a list of
your top 5 after your top 5 after school snacks school snacks
![Page 21: Excel: Graphs & Charts](https://reader036.vdocuments.us/reader036/viewer/2022062302/568167e5550346895ddd4f74/html5/thumbnails/21.jpg)
Creating a Graph / Creating a Graph / ChartChart
On your mark….On your mark…. Get set …Get set … Go to ExcelGo to Excel