Highlight or Add Some sort of Designation to Specific Individuals, not Numbers-Related

[kjv1611]

For some charts we built at work, many of which are built in Excel, though some are built in Reporting-Services, we are being asked more often to differentiate those individuals who are "full time" on a particular project or work-type as compared to those who only help out in that area as needed.

So, I was wondering if anyone here had any particular tricks or methods you've used to somehow highlight specific users, assuming you do have some field set in the data to signify "this is on A TEAM". Of course, I cannot always query that piece directly, though sometimes that will be possible - and possibly in the near future, it will be even more possible. But for now, I'm somewhat stuck with having managers tell me who is where, or allowing them to manipulate charts for this purpose, manually.

One recent way one manager has done this is simply putting a star image next to those who were on "A TEAM" and not others. Another manager simply separates those who work the process as a standard/normal practice from those who just help on occasion by inserting a gap / empty row of data between.

Does anyone have any other methods? For instance, any way to neatly show this differentiation possibly in the legend or tastefully within the chart itself?

I'm mainly dealing with combination column/line charts in case that makes any difference.

Thanks in advance for any thoughts or references.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

 

[SkipVought]

hi,

Why not a conditional format using MATCH in a list?

So how many teams are there?

BIG HUGE mistake to allow users to manage a list. You're open to all sorts of anomalys.

 

[SkipVought]

sorry, Steve, I missed "Charts."

So this is not a CF issue. Merely the use of a CONTROLLED LIST.

But with this sketchy requirement, in a Chart, that seemingly has employee names, some symbols could be used and a separate "legend" in a Textbox could identify them.

 

[kjv1611]

Thanks for the thoughts and sorry for the delay in responding. Working on a few non-related projects, and this one is shelved until probably Monday afternoon or so. I'll get back to it then.

It's annoying right now. There's another separate project ongoing which will hopefully simplify some of this type of reporting, or so it sounds at this point. And this is why so much of it has been so manual to date.



"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57