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

Chapter 18. Building Complex Charts

  • Combination charts

    Combination charts use two chart types or two value (Y) axes to present different types of data on one chart.

  • Analyze data with charts

    Use charts to do what-if analyses and to visually adjust an outcome value and see the effects on the input values.

  • Trendlines

    Add a trendline to a data series to analyze trends and make predictions.

  • Error bars

    Error bars enable you to visually represent the margin of error or degree of uncertainty in a data series.

  • Charts from outlines

    You can create a chart from an outline that uses all of the data in the outline or only the data that is actually displayed.

  • Picture charts

    Visually enhance your charts by replacing data markers and plot and chart backgrounds with pictures.

When you have a situation that requires special charts or you need to go beyond the fundamentals in modifying and formatting charts, the techniques in this chapter will help you. Use Excel's powerful charting features to plot individual data sets differently on the same chart, making it easy to compare different types of data. You can add trendlines and error bars to your charts to make them even more informative. Add visual impact to your charts by replacing data points with graphics.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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