making the fill gradiant reliant on another source range

[travacc]

Hi,

I would like to create a bar chart where the value is from one column
however the fill gradiant comes from another column. i.e. column 1
sales is the first axis however the fill of that axis is based on net
profit in column 2... Does anyone know if this is possible in Excel
2007 or below?

Cheers
James

 

[ShaneDevenshire]

Hi,

I don't believe this is doable, even in 2007. What you are asking for is
conditional formatting for a chart.

 

[Del Cotter]

I would like to create a bar chart where the value is from one column
however the fill gradiant comes from another column. i.e. column 1
sales is the first axis however the fill of that axis is based on net
profit in column 2... Does anyone know if this is possible in Excel
2007 or below?

This sounds like conditional formatting of columns, and the usual method
of doing this in Excel is to have many columns per value, and set them
to zero or NA() or FALSE when the condition does not apply. Like so:

Gr1 Gr2 Grval Y
0 4.5 #N/A 1 4.5
1 8.9 #N/A 1 8.9
3 #N/A 6.7 2 6.7


The first column is the x-value.
The second is the first column style.
The third is the second column style.
The fourth is the number that controls which column has the y-value and
which is NA().
The fifth is the y-value.

Use some conditional formula like IF() to control which column gets the
NA() value.