LinkBack URL
About LinkBacks
I have two groups of sales persons I need to show on one bar chart, from most sales to least. Is there any way to colour code or differentiate the sales persons to show which group they are from?
Thanks for any ideas
I have two groups of sales persons I need to show on one bar chart, from most sales to least. Is there any way to colour code or differentiate the sales persons to show which group they are from?
Thanks for any ideas
Last edited by BRISBANEBOB; 03-22-2010 at 08:40 PM.
Are you plotting each person in each group or are you plotting just two groups (each as an aggregate)?
Format the color of each chart series and relate the groups to that color.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
What if have done is create one table from two groups. Using conditional formatting in the spreadsheet, I can colour code the names in the combined table to show which group they originated from. That is what I am trying to do in the chart which is derived from the combined table.
Not sure I have a complete understanding, but it sounds as of you only need to format the fill color of the bars to match the assigned group color.I can colour code the names in the combined table to show which group they originated from. That is what I am trying to do in the chart which is derived from the combined table.
Perhaps if you upload a sample workbook we can better understand.
Sorry about unclear explanations - I've attached a sample chart. I need to colour code the names of the sales persons on the horizonatal axis which are intermixed from the two different groups.i.e. the top and the bottom and three in the middle could be from goup A and the rest from Group B
It would be better if your workbook contained an actual table of values. However, see if the attached is what you intended. I deleted your original chart and created a mock up to simulate what I understand you wanted regarding differentiation of salesmen to the product group.
If the chart isn't correct, edit your previous post to provide a workbook with the values for the series.
Sample edited as requested...
Well, I meant that you should provide YOUR original data and structure, not modify what I mocked up.I have two groups of sales persons I need to show on one bar chart, from most sales to least. Is there any way to colour code or differentiate the sales persons to show which group they are from?
If the mod you made to my example reflects your real workbook then it is not possible to distinguish them when you have sales people belonging to both product groups. Each group would need to be in a separate series as I showed.
The way I modified your mock up is an accurate reflection of what I'm trying to achieve. Thanks for your help, I didn't realise that what I was trying to do was impossible.
Bob, for conditional formatting in charts you need to fine-tune your data layout and add some data as additional series.
See attached.
Telylyn (again...)
That's a very clever solution and I'll use it. Thanks.
Perhaps I am not understanding or am otherwise missing something here but, I fail to see where in the chart sales people are distinguished per product type as you originally requested.
Even with the additional series and use of Conditional Formatting you still end up with the same stacked bar per sales person and each bar includes both product types.
You are right in that the product types are now shown as separate colours. But...while you can't apparently change the sales persons name, which was the original intention, you could structure it at Teylyn suggested, format Product A and Product B to exactly the same colours except that in the case of Acme, for example, you put a white (or any other colour) pattern over the top. That way you know who is from Acme.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks