Multiple backgrounds in Excel charts

%3CLINGO-SUB%20id%3D%22lingo-sub-1584924%22%20slang%3D%22en-US%22%3EMultiple%20backgrounds%20in%20Excel%20charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1584924%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20Is%20it%20possible%20to%20have%202%20different%20styles%20of%20background%20in%20one%20Excel%20chart%2C%20eg%20gradient%20AND%20pattern%2C%20either%20at%20the%20vhole%20chart%20area%20or%20one%20at%20a%20specific%20section%20and%20the%20other%20one%20at%20the%20other%20section%3F%3C%2FP%3E%3CP%3EIf%20not%2C%20are%20there%20any%20other%20possibilities%20how%20I%20could%20implement%20that%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1584924%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-1585104%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20backgrounds%20in%20Excel%20charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1585104%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EThough%2C%20I%20haven't%20tries%20it%20before.%20But%20I%20think%20you%20should%20be%20able%20to%20apply%20for%20instance%2C%20gradient%20to%20the%20Chart%20Area%20and%20Pattern%20to%20the%20Plot%20Area%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1586148%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20backgrounds%20in%20Excel%20charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1586148%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3EHi%2C%20thanks%20for%20the%20answer.%20I%20see%20that%20I%20didn't%20use%20the%20proper%20terms.%20So%20I%20would%20like%20to%20apply%20pattern%20and%20gradient%20in%20the%20PLOT%20area%20(as%20a%20background%20to%20my%20bar%20graph)%2C%20both%20at%20the%20same%20time.%20It%20seems%20that%20only%20one%20selection%20at%20a%20time%20is%20possible.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1586266%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20backgrounds%20in%20Excel%20charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1586266%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F757485%22%20target%3D%22_blank%22%3E%40janabug%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20switch%20background%20by%20VBA%20or%20lock%20the%20chart%20to%20the%20cell%20and%20change%20conditionally%20cells%20colors%20having%20chart%20area%20transparent.%20Both%20approaches%20are%20described%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fchandoo.org%2Fwp%2Fconditionally-format-chart-backgrounds%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EConditionally%20Format%20Chart%20Backgrounds%3C%2FA%3E%26nbsp%3B%20and%20in%20some%20other%20places.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi, Is it possible to have 2 different styles of background in one Excel chart, eg gradient AND pattern, either at the whole chart area or one at a specific section and the other one at the other section?

If not, are there any other possibilities how I could implement that?

 

Thanks.

3 Replies
Highlighted
Hello,

Though, I haven't tries it before. But I think you should be able to apply for instance, gradient to the Chart Area and Pattern to the Plot Area
Highlighted

@Abiola1Hi, thanks for the answer. I see that I didn't use the proper terms. So I would like to apply pattern and gradient in the PLOT area (as a background to my bar graph), both at the same time. It seems that only one selection at a time is possible.

Highlighted

@janabug 

You may switch background by VBA or lock the chart to the cell and change conditionally cells colors having chart area transparent. Both approaches are described here Conditionally Format Chart Backgrounds  and in some other places.