My Online Training Hub

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

Series excel chart|Dashboards & Charts|Excel Forum|My Online Training Hub

You are here: Home / Series excel 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
Series excel chart
Avatar
Marsil Sarvis
Member
Members
Level 0
Forum Posts: 73
Member Since:
September 6, 2019
sp_UserOfflineSmall Offline
1
November 6, 2020 - 8:23 am
sp_Permalink sp_Print

Hi,

Please can you help me as I want to change the color based on the percentage. please check attached file.

Example: less than 50  >>> Red

               between 50 & 70 >>> Yellow 

               above 70  >>> Green

Thanks;

Marsil

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4619
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
2
November 6, 2020 - 8:37 pm
sp_Permalink sp_Print

Hi Marsil,

There's no conditional formatting in charts, so you need to create 3 separate series, one for each colour. See example file attached. You can change the value in cell AD3 and it will alter the chart bar colour according to your rules.

Mynda

Avatar
Duncan Williamson
Member
Members
Level 0
Forum Posts: 11
Member Since:
December 23, 2020
sp_UserOfflineSmall Offline
3
December 23, 2020 - 12:09 pm
sp_Permalink sp_Print

Try this, it worked for me!

Sart by creating a 2D column chart with your data

Right click on one of the bars ... Format Data Series

Fill ... tick the option to Vary colors by point ... your two bars should now show as different colours ... you can change the colours as you wish

Convert that chart to Stacked Bar Chart and your bars should stay coloured ... as far as I can see, that is the chat you are trying to create

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4619
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
4
December 24, 2020 - 8:04 am
sp_Permalink sp_Print sp_EditHistory

Nice tip, Duncan! Although in this case it won't automatically update based on the values and the colour scales Marsil wants.

Avatar
Duncan Williamson
Member
Members
Level 0
Forum Posts: 11
Member Since:
December 23, 2020
sp_UserOfflineSmall Offline
5
December 24, 2020 - 11:38 pm
sp_Permalink sp_Print

Thanks, Mynda.

I have to confess that I did not go as far as changing any of the variables to test the thing fully so it's good to know that follow up.

 

Duncan

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Tiffany Kang, QSolutions Group
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
Hans Hallebeek: 185
Newest Members:
Kate Dyka
Kwaje Alfred Mogga
thong nguyen
Appiagyei Kofi Frimpong
Hilary Burchfield
Richie Wright
Adel Kock
Barbara Murray
Doug Milne
Siobhan Stringer
Forum Stats:
Groups: 3
Forums: 24
Topics: 6547
Posts: 28656

 

Member Stats:
Guest Posters: 49
Members: 32832
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen