Naming Charts based on Range...

[mettekr]

Hi everyone,

I have some sweet code to sort my data and create tabs/charts through some filtering. I altered it a bit for another application, and it still works really well, but the charts are now statistical control charts. It's a scatter plot, then with horizontal lines for the mean, upper control limit, and lower control limit...i'd like the chart title to lookup the values for those horizontal lines and show it...

If someone jumps on board, I'll post my excel file and visualize what I'm trying to achieve

[mdbct]

You'd be better served if you posted the workbook first instead of forcing us to ask you to let us help you.

[Andy Pope]

Change the cell reference to that of the cell that contains the Mean value.

Please Login or Register  to view this content.