View Single Post
  #3  
Old April 5th, 2010, 03:45 PM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default Excel 2007 format High Low plot area

If you want to shade the region defined by the high and low, use area
chart type series. The first should plot the low value, the second
should plot the (high minus low). Format the low series so it has no
fill, and the (high minus low) series so it has the fill color you want.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 4/2/2010 11:03 AM, RNegus wrote:
User wants to shade plot area instead of show "high low lines" in a Line
Chart. Any suggestions?