Hi,
I would need your help regarding dynamic data label coloring.
My target is to color by green the max value and by red the min value.
See the actual status of the chart in attached.
Thank you in advance the help!
Hi,
I would need your help regarding dynamic data label coloring.
My target is to color by green the max value and by red the min value.
See the actual status of the chart in attached.
Thank you in advance the help!
You can sort of fake it with adding data label to Max and Min series, and making it Solid fill to hide what's behind it.
For something more robust, you'll likely need VBA.
If I understood your requirement correctly, you can try something like this.
Right click on Sample Sheet Tab --> View Code --> Paste the code given below into the opened code window --> Close the VB Editor --. Save your workbook as Macro-Enabled Workbook.
Please Login or Register to view this content.
Last edited by sktneer; 03-23-2017 at 05:39 AM. Reason: Removed unnecessary line of code which was Debug.Print
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
In order to have robust result, what would be the best VBA way?
Thank you very much sktneer!
You're welcome Villalobos! Glad I could help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks