My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

How to display data label as a percentage in a combo chart|Dashboards & Charts|Excel Forum|My Online Training Hub

You are here: Home / How to display data label as a percentage in a combo chart|Dashboards & Charts|Excel Forum|My Online Training Hub
Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
How to display data label as a percentage in a combo chart
Avatar
frederic latour
Member
Members
Level 0
Forum Posts: 7
Member Since:
February 18, 2021
sp_UserOfflineSmall Offline
1
October 27, 2022 - 9:10 pm
sp_Permalink sp_Print sp_EditHistory

Hello,

 

I have a combo chart made of 5 clustered column charts and 1 line chart.

Even if I'd like the clustered column charts to be based on an axis of the values, I'd like also that the data label (in red in the current chart) show the percentage for the year.

Example-with-Percentage-Picture.pngImage Enlarger

Any idea how to do it.

Thanks in advance

Fred

 

PS: The chart is based on a pivot table.

sp_PlupAttachments Attachments
Avatar
Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members

Moderators
Level 1
Forum Posts: 1046
Member Since:
January 31, 2022
sp_UserOfflineSmall Offline
2
October 27, 2022 - 11:08 pm
sp_Permalink sp_Print

Perhaps not the most elegant way but you can create a second pivot table that shows each of the values as a % of the column total. Then you can point the labels to cells in that pivot table. Have a look at the attached file.

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 6
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 925
Purfleet: 415
Frans Visser: 349
Hans Hallebeek: 343
David_Ng: 312
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Hiroyuki Murai
Mark Allen
Yves Gagnon
PATRICK WALTER
Carley Brice
Ash Rahman
Christelle Lamprecht
Wei Kwok Tey
Partha Pratim Nandy
Inge Rousseau
Forum Stats:
Groups: 3
Forums: 25
Topics: 7087
Posts: 31061

 

Member Stats:
Guest Posters: 49
Members: 34503
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen