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
You'd be better served if you posted the workbook first instead of forcing us to ask you to let us help you.
Change the cell reference to that of the cell that contains the Mean value.
Code:With ActiveChart .HasTitle = True .ChartTitle.Text = "Mean = " & Range("B2").Text End With
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks