1 / 15

Graphing Data in Excel

Graphing Data in Excel. The Chart Wizard Making a Chart Perfect Making New Charts Without Making New Charts. Let’s Get Some Data to Chart (Graph). Open the Training Materials folder on the desktop icon next to heading of Agenda & Materials page of CD when you’re home

tannar
Download Presentation

Graphing Data in Excel

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. Graphing Data in Excel The Chart Wizard Making a Chart Perfect Making New Charts Without Making New Charts

  2. Let’s Get Some Data to Chart (Graph) • Open the Training Materials folder on the desktop • icon next to heading of Agenda & Materials page of CD when you’re home • Double Click on MMS Reading.xls • When it opens it should look very familiar

  3. The Chart Wizard • Highlight the data you want to put on a Chart • We’ll start with 5th grade change data (M12:P15) • Tap the Chart Wizard icon (tool bar).

  4. The Chart Wizard (Cont.) • 1st Page of the Wizard (Chart Type) • Tap on a picture of Chart • It tells you what type of Chart • Clicking the bar below shows a small version of what it would look like • Select the Clustered Column with 3-D Visual Effect (Select it and Click Next).

  5. The Chart Wizard (Cont.) • 2nd Screen (Selecting X / Y data) • Defaults to Series being in rows • Click Columns to see what it does • Go back to Rows before you click Next.

  6. The Chart Wizard (Cont.) • 3rd Screen (Labeling and Formatting) • Labeling the Chart and the Axes* • Axes* • Gridlines* • Legend* • Data Labels* • Data Table* • When everything is right, click Next.

  7. The Chart Wizard (Cont.) • 4th Screen (Where to put the chart) • As a new sheet • Inserts a new worksheet in your workbook and puts the chart there • Type a name for the chart (5th Chng 01-02) • As an object in • Puts the chart as a picture on the existing sheet of your choice • Select As a new sheet but… DON’T CLICK FINISH YET!

  8. The Chart Wizard (Cont.) • Moving back and forth in Wizard • Click on back to move to the previous screen • Next to move to the next • Only click Finish when you’ve got it right • When you have the Chart looking like you want and headed for a new sheet, click on Finish • You can re-enter the Wizard at any time by selecting the chart and again clicking the Chart Wizard Icon

  9. Formatting / Editing a Chart • Select the element you want to change • Little black boxes will appear at corners • Go to Format / Selected… • What appears behind selected depends on what you have selected • You can now change whatever appears for the element you’re working on • Format Y Axis / Scale (min -15 to max 15) • Format Data Series / Fill Effects / Pattern • Click OK to change the chart.

  10. Charting Equivalent Data (Cont.) • Copying the Chart • Select the Sheet with 5th Chng 01-02 • Edit / Move or Copy Sheet or Right Click / Move or Copy Sheet • Click box by Copy Sheet • Select sheet in front of which the new sheet will go • Click OK • Rename the new sheet (8th Chng 01-02) • Format / Sheet / Rename or Right Click / Rename

  11. Charting Equivalent Data (Cont.) • Changing Data on Chart • Chart / Source Data • Select Equivalent 8th Grade Data Table • Click OK • The Chart now reflects the 8th grade numbers • Could you copy this data table so that it calculates 02-03 change?

  12. Using the Chart Wizard • Select the 5th grade total met data table • Click on the Chart Wizard icon • Use the wizard to create your chart • Save it on a new worksheet (5th Total Met)

  13. Adjust the Scale • Right Click on the vertical axis • Click on Format Axis • Click Scale tab • Adjust Maximum to 100 • Make any other changes to the chart you see fit

  14. Replicating the Chart • Copy the chart to a new worksheet • Rename the new worksheet • Chart / Source Data • Select the 8th grade data • Make needed changes to make it the 8th grade graph

  15. Okay Charters Extraordinaire… • You can now • Create data tables suitable for the Chart Wizard • Use the Chart Wizard to create graphs • Make changes to the resulting chart • Copy graphs • Retarget the graph’s source data to create graphs of new data

More Related