I haven't gotten any further on this.
I am having the biggest difficulty figuring out how to get column and row information from charted data
In a chart, series are specified like:
=SERIES[ (series_name) , (X-values) , (Y-values) , (plot_order) ].
Range references in a SERIES formula are always...
I could probably solve some of the issues by asking the user what column the data is in, what row to start with, and what column to change the colors by.
I haven't done that because I would like to take the chart as plotted and have it automatically update the colors, even if the range is...
Instead of data labels, I sometimes go in and manually change data point colors based on values in another column (like yield values that are graphed and color changes based on input material lot number). What is annoying about this is if the data range of the graph is changed, the colors that...
