View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lee Lee is offline
external usenet poster
 
Posts: 7
Default 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.