Horizontal line on line chart
I need to create a horizontal lines on a line chart that indicates when the
data is over (UCL) or under (LCL) a control limit. Is there a slick way to do this in VBA without actually putting the UCL or LCL values in cells. The upper control limits (UCL) and (LCL) values are generated from the data statistically. |
Horizontal line on line chart
In my opinion, the slick way is to put formulas into cells that calculate
the LCL and UCL and graph them as part of the raw data. Then if you size the chart or change the data, they are adjusted automatically. You can always hide the rows or columns if you don't want to see the raw data. -- Regards, Tom Ogilvy "Lee" wrote in message ... I need to create a horizontal lines on a line chart that indicates when the data is over (UCL) or under (LCL) a control limit. Is there a slick way to do this in VBA without actually putting the UCL or LCL values in cells. The upper control limits (UCL) and (LCL) values are generated from the data statistically. |
All times are GMT +1. The time now is 02:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com