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

Part III: Creating Charts and Graphics > Advanced Chart Topics

Chapter 11. Advanced Chart Topics

by Bruce Hallberg

  • Editing chart series formulas

    For advanced users, the ability to directly edit chart series formulas often comes in handy. Here, you learn how chart series formulas work and how to edit them.

  • Adding a second Y-axis

    When plotting data that includes a series that uses a radically different set of values, a second Y (or value) axis often makes sense.

  • Using logarithmic scales

    Excel lets you designate certain axes as using a logarithmic scale, which can often reveal detail that you otherwise can't see.

  • Creating trend lines

    Trend lines typically represent linear regressions of the chart data, and often can be used to predict future trends.

  • Using graphic images as data markers

    Excel lets you use graphic images for certain chart types, much like the graphs that you often see in newspapers where charts are created with stacked cars or dollar bills.

  • Creating map charts

    Map charts let you easily create charts that incorporate maps of parts of the world.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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