Suppose I have a bunch of tables with time series data for US states labelled by 2 digit code, and each table will be used to create a line chart that will be put in a common dashboard. How can I guarantee all lines for each state use the same color for a given state ?
I imagine I could create a secondary table with colors chosen for each state
and then after a table join by 2 letter code, use some type of conditional formatting.
I am not sure this is the best step since I will need to complicate the data with the extra join?
Any examples or suggestions?
I have not yet attempted conditional formatting and could use an example of this step.
Post a packaged workbook with an example of what you're trying to accomplish and I'll take a look.