1 / 15

Spreadsheets III: Layout and Charts

Learn about workbooks, worksheets, toolbars, headers and footers, page setup, print preview, print, chart types, and chart options in management information systems.

dfoster
Download Presentation

Spreadsheets III: Layout and Charts

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. Spreadsheets III: Layout and Charts Lecture 10, May 8, 2003 Mr. Greg Vogl Management Information Systems I Uganda Martyrs University

  2. Overview • Workbooks, Worksheets and Windows • Toolbars • Headers and Footers • Page Setup, Print Preview, Print • Chart Types • Chart Options Management Information Systems I: Spreadsheets III: Layout and Charts

  3. Workbooks, Worksheets, Windows • Click Insert, Worksheet; Edit, Delete Sheet • Shift-click worksheet tabs to select more than one • Double-click the worksheet tab to rename it • Press Ctrl-Page Up or Down to view another sheet • Click File, New to create a new workbook • Click Window, New for additional window views • Click Window, Arrange to see several at once Management Information Systems I: Spreadsheets III: Layout and Charts

  4. Toolbars • View, Formula Bar or Status Bar • View, Toolbars: Standard, Formatting, Chart • View, Toolbars, Customize • Standard and Formatting toolbars share one row • Menus show recently used commands first Management Information Systems I: Spreadsheets III: Layout and Charts

  5. Header and Footer • Click View, Header and Footer • Choose pre-formatted or custom header and footer • Click in Left, Center or Right section • font, page no., no. of pages, date, time, file, tab Management Information Systems I: Spreadsheets III: Layout and Charts

  6. Page Setup • Page • Orientation: Portrait, Landscape • Scaling: % of normal size, fit to # of pages; Paper Size • Margins • Top, Bottom, Left, Right, Header, Footer • Center on page: Horizontally, Vertically • Sheet • Print Area, Print Gridlines, Rows/Columns to Repeat Management Information Systems I: Spreadsheets III: Layout and Charts

  7. Print Preview and Print • Print Preview • Next, Previous, Zoom, Print, Setup, Margins, Close • Print • Printer: Name, Properties, Status, Type, Where, etc. • Print range: All, Pages From: and To: • Copies: Number of Copies, Collate • Print what: selection, active sheet(s), entire workbook Management Information Systems I: Spreadsheets III: Layout and Charts

  8. Chart Wizard • Click Insert, Chart or the Chart Wizard button • Complete the following four steps: • 1. Chart Type (and Sub-type) • 2. Chart Source Data (data range, series) • 3. Chart Options (titles, legend, data labels) • 4. Chart Location (new sheet, or object in a sheet) Management Information Systems I: Spreadsheets III: Layout and Charts

  9. Step 1 of 4: Chart Types • Column: vertical bars (rectangles) • Bar: horizontal bars • Line: connected dots • Pie: circle divided into sections • Scatter (XY): points with X and Y values • Area: solid fill beneath lines • Doughnut: pies with holes in the middle Management Information Systems I: Spreadsheets III: Layout and Charts

  10. Chart Sub-types • Stacked: 2 or more series added • 100%: stacked and shown as percent of whole • Exploded: pie sections separated for emphasis • 3-D visual effect: looks solid instead of flat • Markers: large shapes at data points • Straight or smoothed lines: connect data points • Button to press and hold to view sample Management Information Systems I: Spreadsheets III: Layout and Charts

  11. Step 2 of 4: Chart Source Data • Data range: can be selected now or before wizard • Series in rows or columns • Series list • Add and Remove buttons • Series name • Series values • Category (X) axis labels Management Information Systems I: Spreadsheets III: Layout and Charts

  12. Step 3 of 4: Chart Options • Titles: chart title, XYZ (category/label/value) axes • Gridlines: X/Y, major/minor • Legend: show legend, placement left/right/etc. • Data labels: none, show value/label/percent/etc. • Data table: show data table Management Information Systems I: Spreadsheets III: Layout and Charts

  13. Step 4 of 4: Chart Location • New Sheet • You can print the chart without the data • You can see and print the entire chart on one page • Object in current (or other) worksheet • You can resize the chart • You can print the chart with the data Management Information Systems I: Spreadsheets III: Layout and Charts

  14. Chart Menu • Allows you to go back and change any step • Add data: specify data to use • Add trend line: generalise, forecast • 3D view: look at 3D chart from a different angle Management Information Systems I: Spreadsheets III: Layout and Charts

  15. Chart Toolbar • Chart objects menu: select part of chart to format • Properties button: format chart objects • Chart type menu: select a different type of chart • Legend button: hide/show legend • Data table button: hide/show data table • By row/column button: change data series Management Information Systems I: Spreadsheets III: Layout and Charts

More Related