Forum

Notifications
Clear all

Quadrant chart - show Value from cells labels on hover

6 Posts
3 Users
0 Reactions
363 Views
(@vickiet)
Posts: 3
Active Member
Topic starter
 

Hi there,

I have designed a quadrant chart from a scatter graph and I want to see my student names on hover.  I have them displayed on the chart by selecting the column as a range in Labels / Value From Cells but there are multiple that overlap making them illegible.  Is there a workaround to show the Student name on hover?

Thank you 

 
Posted : 09/02/2023 4:29 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Victoria,

You can either manually drag them away from one another so they have more space, or you can use this technique to give the labels more information on hover.

Mynda

 
Posted : 09/02/2023 5:50 am
(@vickiet)
Posts: 3
Active Member
Topic starter
 

Thanks for your help.  The VBA looks very complicated and is not something I have experience using.  Maybe it's time for me to investigate this!

 
Posted : 09/02/2023 11:09 am
(@jstewart)
Posts: 216
Estimable Member
 

Mynda, that's so cool, I never knew it was a possibility! Do you have that demonstration as a video topic in the future?

 
Posted : 09/02/2023 1:58 pm
(@vickiet)
Posts: 3
Active Member
Topic starter
 

I would love to see a demo video too should you decide to make one.  Thank you 

 
Posted : 10/02/2023 5:47 am
(@mynda)
Posts: 4761
Member Admin
 

I don't have a video demo for this, but I am considering doing one, but it won't be for a while.

 
Posted : 10/02/2023 8:35 am
Share: