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: 4769
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: 4769
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: G Thomas
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 919
Purfleet: 415
Frans Visser: 349
Hans Hallebeek: 336
David_Ng: 306
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Miguel Costa
Nick Dowling
Silvia Ramos
Muhammad Abdullah Asad
Ifeanyi Aghanama
Ann Crossman
Kate Manders
James Carabott
Steven Venz
Robert Morrison
Forum Stats:
Groups: 3
Forums: 25
Topics: 7066
Posts: 30968

 

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