Aug 12 2020 10:19 AM - edited Aug 12 2020 10:19 AM
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.
Aug 12 2020 11:46 AM
Aug 13 2020 12:24 AM
@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.
Aug 13 2020 02:20 AM
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.