Plot Highs and lows?

[Guest]

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]

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