View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Plot Highs and lows?

Hi,

If I understand the problem then yes 2 extra series would be do it.

Have a look at these examples of highlighting points in a plot.

http://peltiertech.com/Excel/Charts/PointAtPoints.html
http://www.processtrends.com/pg_charts_min_max.htm

Cheers
Andy

John wrote:
I have a chart that pulls in data and updates periodically. Is there anyway
to chart I high and a low value for that day? Would this invlove creating
two other series of data?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info