Conditional Format of the CHART AREA COLOR

J

Justin Luyt

I need to format the CHART AREA COLOR based on a condition. If the data is
higher than a certain amount I need the CHART AREA to be RED.

I do not know VBA too well so please give me as much detail as possable.

Justin
 
A

Andy Pope

Hi,

If your chart is on a worksheet you don't need to use VBA at all.
Make use of conditional formatting instead. Position the chart over a
cell or range of cells. Then format the chart area to have no fill. This
will make the chart transparent such that when the chart is not active
the cells beneath are visible. Then when CF is applied any colour will
show through.

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I partially fill a plot area with color? 4
Contour Chart - Find Vals for Shaded Areas 0
Odd Chart Format Results 1
Conditional Formatting - Apply to Charts? 1
changing area color based on line value 2
XL 07 - add color to specific part of plot area 1
Conditional Formatting of Bar Charts 2
Conditional Format of the Chart AREA COLOR 1

Top