Plot Highs and lows?

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?

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