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? |
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 |
All times are GMT +1. The time now is 08:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com