Microsoft® Office Excel 2003 Inside Out

Chapter 26. Working with Chart Data

• Adding Data

• Using List Features to Create Expanding Charts

• Removing Data

• Changing or Replacing Data

• Plotting or Marking Every nth Point

• Changing the Plot Order

• Using Multilevel Categories

• Adding Trend Lines

• Adding Error Bars

• What-If Charting: Dragging Markers to Change Data

Charts have a way of changing over time. New data arrives, old data becomes obsolete or irrelevant, and new visual comparisons become meaningful. In this chapter, you look at Microsoft Excel's procedures for working with the data that drives your charts. You'll see how to add new points and series to a chart, how to change the order in which Excel plots your series, and how to plot multilevel categories of information. You also look at Excel's features ...