• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Lock the labels in a pie chart

Dillina

Member
Hello guys,
I'm still here for your advice. :)
This time I would like to know if there is the possibility of "blocking" the labels with the percentages in the chart.

I have a hand (picture above the graph) :rolleyes:
For the moment it is not dynamic and I have only entered January 2018, but in the future I will make it dynamic so that the months change.

In this way, the image and the labels are perfect because I have placed them by hand but if I change the numbers in column B, (obviously the% change in the chart) labels, however, move .... :(

Is there a possibility to block labels?
So when I change the months, the thumb does not position itself in the place of the little finger (for example)

I wait for good news !! :):awesome:
 

Attachments

  • Finger.xlsx
    461 KB · Views: 11
If position doesn't need to change, there's no need to use a graph. Let's just use your hand image and some floating text boxes. In the attached, you can see where I calculate the percentage, build the label text, and then linked it to the floating text boxes.
 

Attachments

  • Finger LM.xlsx
    431.8 KB · Views: 21
Dillina
I would use 'Your hand' as picture with chart ... not separate
(if You move hand or chart ... not match).
.. and You can set Your fingers value places as Your hand needs.
>> Something like this?
 

Attachments

  • Finger.xlsx
    643.1 KB · Views: 17
If position doesn't need to change, there's no need to use a graph. Let's just use your hand image and some floating text boxes. In the attached, you can see where I calculate the percentage, build the label text, and then linked it to the floating text boxes.

What a BRILLIANT idea, Luke!!!! :eek:
Me gusta muchisimo!!!! :)
I try it immediately in my original file!
Thank you very much!! :)
 
Dillina
I would use 'Your hand' as picture with chart ... not separate
(if You move hand or chart ... not match).
.. and You can set Your fingers value places as Your hand needs.
>> Something like this?

Vletm!!! :)
What can I say? In Italy we said " La classe non è acqua "
I believe that in English is "The class is not water", but I do not know if it makes sense :rolleyes:
It means that your level is always very high.
Your solution is also WONDERFUL that I will try immediately.

Thank you so much for your idea! :)
 
Guys....you are always impressively good.
Luke, I'm still thinking of your intelligence for a "simple" but very smart solution.
Vletm very good as always!
Guido too, Hui .... all of the champions
I love Excel and with you, even more
and sorry for my bad english
:)
 
Back
Top