Home

Change bar graph color based on cell color

%3CLINGO-SUB%20id%3D%22lingo-sub-687394%22%20slang%3D%22en-US%22%3EChange%20bar%20graph%20color%20based%20on%20cell%20color%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-687394%22%20slang%3D%22en-US%22%3E%3CP%3ETrying%20to%20figure%20out%20how%20to%20change%20bar%20graph%20colors%20based%20on%20the%20color%20of%20cells.%20In%20older%20excel%20versions%20there%20was%20a%20button%20that%20said%20%22apply%20cell%20colors%20from%20spreadsheet%22.%20The%20cells%20are%20colored%20from%20conditional%20formatting%20if%20that%20matters.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20395px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117900iF1C74E12A88F7DBB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.PNG%22%20title%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20454px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117901iAC659DE0DDA18CD3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture2.PNG%22%20title%3D%22Capture2.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-687394%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-687736%22%20slang%3D%22en-US%22%3ERe%3A%20Change%20bar%20graph%20color%20based%20on%20cell%20color%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-687736%22%20slang%3D%22en-US%22%3EI%20am%20not%20aware%20of%20such%20an%20option%20and%20I've%20been%20using%20Excel%20since%201996.%20That%20being%20said%2C%20if%20you%20need%20conditional%20colors%20for%20a%20bar%20chart%2C%20the%20way%20to%20implement%20that%20is%20to%20have%20a%20separate%20column%20of%20data%20for%20each%20condition%20which%20contains%20either%20a%20value%20when%20the%20condition%20is%20met%2C%20or%20%23N%2FA%20when%20not.%20A%20bit%20complicated%20to%20explain%2C%20Jon%20Peltier%20does%20a%20pretty%20good%20job%20here%3A%20%3CA%20href%3D%22https%3A%2F%2Fpeltiertech.com%2Fconditional-formatting-of-excel-charts%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpeltiertech.com%2Fconditional-formatting-of-excel-charts%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-687904%22%20slang%3D%22en-US%22%3ERe%3A%20Change%20bar%20graph%20color%20based%20on%20cell%20color%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-687904%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3BI'll%20take%20a%20look%20and%20see%20if%20I%20can%20make%20it%20work.%20This%20is%20the%20youtube%20video%20that%20I%20referenced%20before%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D0kb720KJxNs%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D0kb720KJxNs%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20basically%20what%20I'm%20trying%20to%20accomplish%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-692970%22%20slang%3D%22en-US%22%3ERe%3A%20Change%20bar%20graph%20color%20based%20on%20cell%20color%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-692970%22%20slang%3D%22en-US%22%3EAha%2C%20that%20video%20demonstrates%20use%20of%20an%20add-in%20(Mekko%20charts%3F)%20which%20apparently%20has%20the%20capability%20you're%20looking%20for.%3C%2FLINGO-BODY%3E
Torifox43
Occasional Contributor

Trying to figure out how to change bar graph colors based on the color of cells. In older excel versions there was a button that said "apply cell colors from spreadsheet". The cells are colored from conditional formatting if that matters. 

 

Capture.PNGCapture2.PNG

3 Replies
I am not aware of such an option and I've been using Excel since 1996. That being said, if you need conditional colors for a bar chart, the way to implement that is to have a separate column of data for each condition which contains either a value when the condition is met, or #N/A when not. A bit complicated to explain, Jon Peltier does a pretty good job here: https://peltiertech.com/conditional-formatting-of-excel-charts/

@Jan Karel Pieterse I'll take a look and see if I can make it work. This is the youtube video that I referenced before: https://www.youtube.com/watch?v=0kb720KJxNs

 

It's basically what I'm trying to accomplish

Aha, that video demonstrates use of an add-in (Mekko charts?) which apparently has the capability you're looking for.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies