Hi, I am hoping to find an answer to a challenge I am currently having with pivot tables.
The requirement is to pull the same set of monthly charts each month which contain data related to our providers. The challenge is for the charts to always display the same chart color for a given provider from chart to chart. The caveat is that some charts may not yield any data for a given provider.
Is there a way to define a rule that assigns a pre-defined chart color regardless of the presence or absence of a person/provider in the chart and for a color to always be associated with a given provider?
Thank you in advance for your insight.
Yavette Griffith
The requirement is to pull the same set of monthly charts each month which contain data related to our providers. The challenge is for the charts to always display the same chart color for a given provider from chart to chart. The caveat is that some charts may not yield any data for a given provider.
Is there a way to define a rule that assigns a pre-defined chart color regardless of the presence or absence of a person/provider in the chart and for a color to always be associated with a given provider?
Thank you in advance for your insight.
Yavette Griffith