Concatenated Legend Series with grouped Colours
Hello!
So I'm trying to group Names by only 3 colors in my chart, Backlog/Won Not Booked/Forecast.
Just like the image below, and the attachment.
But the chart insists on coloring the columns by each Name instead of my 3 previous statements.
Is there a way of doing this automatically, or I will have to create other tables to help me?
If yes, how ?
Thank you!
Capture.PNG
John.
"I excel at jumping to conclusions"
You can create a chart template from the chart you have coloured manually and then apply that to future charts.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Didn't know you could save Templates,
It worked, but partially, since the User can change the "Backlog" cell to "Won not booked"
But that already gave me an idea to workaround, Thanks!
Glad to have helped!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks