close

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.

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

Cheers
Andy

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

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()

E-mail轉寄