Multiple backgrounds in Excel charts

Question

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.

abiola1 · Answer

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

janabug · Answer

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.

sergeibaklan · Answer

janabug&nbsp;
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&nbsp;Conditionally Format Chart Backgrounds&nbsp; and in some other places.

Forum Discussion

Multiple backgrounds in Excel charts

3 Replies

Resources