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

Chapter 11. Advanced Chart Topics > Plotting with a Recommended Range

Plotting with a Recommended Range

A very common need in Excel charting is the capability to chart data against a recommended range. The reader of the chart can then instantly see when data falls outside of this range. For example, it is handy to plot medical lab data against the recommended ranges, or to plot machine tolerances against a recommended range.

You can easily create such charts. What you do is create two additional series of data, one of which describes the minimum recommended value, and one of which describes the maximum recommended value. Figure 11.25 shows some example data properly formatted for creating this chart. Notice that the high recommended value comes before (to the left of) the low recommended value.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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