Charting Primer I

Charting Primer I - ExcelChartingPrimerI ChartingMissingData

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Excel Charting Primer I Charting Missing Data Modifying Chart Series Create a Chart with Series Formulas Combination Charts Use 2 Value Axes in a Chart Graphical Fills Dynamic Chart Titles XY vs. Line Chart Types Correcting Misleading Chart Scales Managing Category Dates Creating a Chart with Multiple Category Labels Locate Chart Tick Marks Adding Labels to XY and Bubble Chart Data Points 3-D Chart Basics Many of the examples in this workbook were adapted  from the text named  Excel Charts , by John  Walkenbach, Wiley,  2003.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
3 Ways to Chart Missing Data Charting Missing Data The three charts in this worksheet show three ways to handle missing data. In the first chart the missing data is not plotted, in the second the missing data is plotted as zeros, and in the third Excel interpolates the missing data. The Data Time Temperature 12:00 AM 28 1:00 AM 27 2:00 AM 27 3:00 AM 24 4:00 AM 26 5:00 AM 32 6:00 AM 35 7:00 AM 38 8:00 AM 40 9:00 AM 10:00 AM 45 11:00 AM 47 12:00 PM 50 1:00 PM 52 2:00 PM 52 3:00 PM 50 4:00 PM 43 5:00 PM 6:00 PM 36 7:00 PM 34 8:00 PM 32 9:00 PM 30 10:00 PM 29 11:00 PM 28 12:00 AM 3:00 AM 6:00 AM 9:00 AM 12:00 PM 3:00 PM 6:00 PM 9:00 PM 0 10 20 30 40 50 60 Temperature Chart 1 - Missing Data Not Plotted 12:00 AM 3:00 AM 6:00 AM 9:00 AM 12:00 PM 3:00 PM 6:00 PM 9:00 PM 0 10 20 30 40 50 60 Temperature Chart 2 - Missing Data Not Plotted as Zeros 12:00 AM 3:00 AM 6:00 AM 9:00 AM 12:00 PM 3:00 PM 6:00 PM 9:00 PM 0 10 20 30 40 50 60 Temperature Chart 3 - Missing Data Interpolated Return to Contents
Background image of page 2
Manipulate Chart Series Manipulate Chart Series      the data series and the regions as the categories. Change the Q1 Sales series name from      "Q1 Sales" to "Quarter 1 (Millions"). The plotting order is changed so the quarter 2 series      markers appear to the left of the quarter 1 series markers and "Q2 Sales" is the top row.      of the legend.      1) All series removed but North, South, East, and West.     3) Y-axis scale chaned from $0 to $70 to $0 to $80 and display labels by 20s on the axis       (that is, $0, $20, $40, $60, $80, and $100) instead of by 10s.      4) A chart data table added. Data Range 1 Region Q1 Sales Q2 Sales North $50  $55  South $45  $42  East $32  $35  West $58  $50  Central $40  $43  NorthWest $35  $35  NorthEast $30  $28  SouthWest $38  $45  SouthEast $42  $48  Data Range 2 Region Q3 Sales Q4 Sales North $58  $56  South $41  $40  East $37  $38  West $49  $52  Central $46  $47  NorthWest $37  $34  NorthEast $24  $22  SouthWest $47  $48  SouthEast $48  $45  Chart 1:  A column chart using data in  Data Range 1  with the quarterly sales values as 
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/20/2011 for the course BUS 101 taught by Professor Ecklund during the Spring '01 term at Duke.

Page1 / 15

Charting Primer I - ExcelChartingPrimerI ChartingMissingData

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online