• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 8: Creating Charts > Working with Chart Data

Chapter 26. Working with Chart Data

Adding Data 667

Using List Features to Create Expanding Charts 670

Removing Data 671

Changing or Replacing Data 671

Plotting or Marking Every nth Point 672

Changing the Plot Order 675

Using Multilevel Categories 675

Adding Trend Lines 678

Adding Error Bars 679

What-If Charting: Dragging Markers to Change Data 679

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 for adding trend lines and error bars.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint