My Online Training Hub

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

Colors for 100% stacked column chart using multi-column IF formulas|Dashboards & Charts|Excel Forum|My Online Training Hub

You are here: Home / Colors for 100% stacked column chart using multi-column IF formulas|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
Colors for 100% stacked column chart using multi-column IF formulas
Avatar
Lisa Yount

New Member
Members
Level 0
Forum Posts: 2
Member Since:
July 14, 2023
sp_UserOfflineSmall Offline
1
July 14, 2023 - 11:11 pm
sp_Permalink sp_Print

I am trying to create a 100% stacked column chart with the top portion of each column a grey color (like pic 2 attached).

I used the Excel Multi-colored Line Charts tutorial and successfully created a chart with the colored bars (pic 1 attached) using IF formulas, but I don't know how to add an additional data series to color grey. When I change the chart type to 100% stacked, it changes the y-axis to a percent, and when I change the category to number, the columns disappear.

I used the excel_chart_multi_colored_line.xlsx file (renamed excel_chart_multi_colored_bar_LY.xlsx, attached). 

I appreciate any help.

LisaPic-1.pngImage Enlarger

Pic-2.pngImage Enlarger

sp_AnswersTopicSeeAnswer See Answer
Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4614
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
2
July 15, 2023 - 10:17 am
sp_Permalink sp_Print

Hi Lisa,

The images uploaded, but the Excel file didn't. Please try again and wait for the grey check mark to appear beside the file size after pressing 'start upload' and before pressing 'submit reply'.

Mynda

Avatar
Lisa Yount

New Member
Members
Level 0
Forum Posts: 2
Member Since:
July 14, 2023
sp_UserOfflineSmall Offline
3
July 16, 2023 - 12:05 am
sp_Permalink sp_Print

Here's the spreadsheet I tried to attach.rnThanks!rnLisa

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4614
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
4
July 16, 2023 - 8:08 pm
sp_Permalink sp_Print sp_EditHistory

Hi Lisa,

You just need to add a column to the source data and chart for the balance of 950 and change the chart type to Stacked Column. See file attached.

Mynda

sp_AnswersTopicAnswer
Answers Post
sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Terry Hedditch, Tracy English, David Panthol, Mohamed Touahria
Guest(s) 10
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
jaryszek: 183
Newest Members:
David von Kleek
Ronald White
Ginette Guevremont
Taryn Ambrosi
Mark Davenport
Christy Nichols
Harald Endres
Ashley Hughes
Herbie Key
Trevor Pindling
Forum Stats:
Groups: 3
Forums: 24
Topics: 6528
Posts: 28594

 

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