Forum Discussion
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...
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
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.
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.
