Hi, I'm not sure if I can do this but I have a series of companies that I need to be labelled as the company but to have a Legend and for the data labels to be coloured as column D not as the X and Y labels (so all companies that are Lloyds - onshore are 1 colour and New Bermudian another colour)
Is there a way anyone knows of that I can do this?
labels Value X Value Y Legend
Ace 17.4 0.89 Traditional Bermudian
Allied World 2.3 0.71 New Bermudian
Amlin 3.2 1.31 Lloyds - Onshore
Arch 4.1 1.05 New Bermudian
Argo 0.9 0.57 New Bermudian
Aspen 2.2 0.83 New Bermudian
Never mind, just reread the thread title.
ChemistB
My 2¢
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
?? - do I need to reread something?Originally Posted by ChemistB
Something like this?
Thanks for the response Andy (I'm a huge fan of your excel site by the way and use it often!!!)
The problem is though is the data labels are Lloyds/Trad Bermudian etc when I need the labels in the scatter chart to be the company names (column A) but to have them coloured as the Legend is.. it may not be possible mind?
Thank you!
Use the chart labeller to link data labels to cells. Then format data labels as required.
http://www.appspro.com/Utilities/ChartLabeler.htm
that's great Andy you are a star, thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks