Prev: Traffic light problem
Next: Problems with Viewing Charts in Excel 2007
From: Zb Kornecki on 27 Jun 2008 13:18
I have a spreadsheet where the font is colored based on conditional
formatting. Is there a way to have the graphed series of these values match
the format color.
Thank-you
Zb
From: Wigi on 27 Jun 2008 17:57
Hi

see here with Jon Peltier:
http://peltiertech.com/Excel/Charts/ConditionalChart1.html


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Zb Kornecki" wrote:

> I have a spreadsheet where the font is colored based on conditional
> formatting. Is there a way to have the graphed series of these values match
> the format color.
> Thank-you
> Zb
From: ShaneDevenshire on 28 Jun 2008 12:44
Hi Zb,

We've been asking Microsoft for conditional formatting in the chart area but
it hasn't happened yet.

You could do it with VBA but that may not be acceptable.

--
Cheers,
Shane Devenshire


"Zb Kornecki" wrote:

> I have a spreadsheet where the font is colored based on conditional
> formatting. Is there a way to have the graphed series of these values match
> the format color.
> Thank-you
> Zb
 | 
Pages: 1
Prev: Traffic light problem
Next: Problems with Viewing Charts in Excel 2007