I have charts fed from a table. The charts update automatically every time new data is entered like they should. My UCL and LCL calculations also are working. I am using a trend line chart. How do I add the UCL and LCL to the chart? Every example I find says to "paste special" in the chart area, except Im running office 365 and there is no "paste special" option shown when I right click on the chart, only paste.
I need the UCL / LCL lines to auto update every time new data is added. In JMP this is a one button push, how do you do something as simple as add a value line to a chart in excel office 365?
I need the UCL / LCL lines to auto update every time new data is added. In JMP this is a one button push, how do you do something as simple as add a value line to a chart in excel office 365?