Forum Discussion
janabug
Aug 12, 2020Copper Contributor
Multiple backgrounds in Excel charts
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 sec...
Abiola1
Aug 12, 2020MVP
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
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
janabug
Aug 13, 2020Copper Contributor
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.
- SergeiBaklanAug 13, 2020Diamond Contributor
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.