LinkBack URL
About LinkBacks
Is there a way to have separate formatting for the label value and the label percentage?
I would like the value to be bold, the percentage to be not bold.
As a starting point, this is the code so far:
Please Login or Register to view this content.
Is there a way to have separate formatting for the label value and the label percentage?
I would like the value to be bold, the percentage to be not bold.
As a starting point, this is the code so far:
Please Login or Register to view this content.
Last edited by AliGW; 03-16-2024 at 01:08 AM. Reason: Code tags added - please review the forum guidelines.
Welcome to the Forum briskie!
Can you attach a file with data so that we can see the chart that is generated by this code, and test solutions?
HI
I think it can't be done (and I hope to be proven wrong) but it would be better to "see" your file, not just the code.
Hi,
Mario
Hi 6StringJazzer,
thank you for the warm welcome!
I have attached two test files.
The first one with the "simple" code without any further font formatting.
The second file has some added code, which comes close to the idea..
There is only one attachment. Perhaps you selected both in the same operation and overwrote the first attachment, rather than uploading a second one.
All of the labels selected have the same font properties. I was trying to create a second copy of the same series and configure different labels, hoping they could be overlaid on the first set. Although the Chart Design Data shows a second series, it is not visible in the chart, so I am stuck for now. If I do it manually it doesn't show the second series, and if I do it in the code, the code runs but also does not show the second series.
Also there is no need to put an End statement in this code.
Last edited by 6StringJazzer; 03-16-2024 at 11:16 AM.
The second file:
And the third file:
The third file has the second series plotted (another set of percentages).
Last edited by briskie; 03-16-2024 at 12:03 PM.
This works (!), the Category Name is Red and Bold, the Percentage is Black and not Bold.
So the question is: how to combine these two codes?
Last edited by briskie; 03-16-2024 at 12:35 PM.
Hi
Try this macro
I'm happy to have been proven wrongPlease Login or Register to view this content.
Hi,
Mario
Hi Mario,
wow, very nice – but ;-)
I really need to have the first code doing the actual labeling first (adding the labels with the cells font color).
Then this second code as a bonus, which only tells the percentage "Bold=False".
Do you see any possibility of combining these?
Please have a look: The first file only contains the labeling code, that's the starting point.
The second file contains both, the labeling code and the one you successfully tweaked.
Hi
Try this new macro
Hi,Please Login or Register to view this content.
Mario
Hi Mario,
wow, truly amazing!
Two last questions, if I may:
1.
How do I get:
Category Name > new line
Category Value > new line
Category Percentage
2.
Where can I insert the Percentage Number Format “0,00%”
I’m playing around, but can’t work it out yet (I just started using VBA a week ago).
Best,
Toni
HI
I have been studying Excel Charts for several years but, as I said before, I didn't know that part of the content of the Label could be colored differently. There is always more to learn!
Regarding your first question (showing data on different lines) modify the part of code like this
For the other question I have no solution. I can't advise you on how to also show the decimal part of the percentage.Please Login or Register to view this content.
I would be happy with what I got.
Hello and happy studying VBA,
Mario
Hi Mario,
thank you so much for your effort, its really great, that it actually works this far!
I will post another question regarding the Number Format, maybe somebody has an idea.
(Unfortunately I need the 2 decimals).
Thanks a lot!
Toni
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks