is there option to set conditional formats on charts ?
like change the color of a column with certain value
is there option to set conditional formats on charts ?
like change the color of a column with certain value
Hello,
I have done this in the past by writing a macro...Excel assigns random colors to charts, so sometimes by changing your data the color of certain columns changes. i could not find the online reference i used but try to find/write the macro to do that.
Hope this will help (i'll look for the code and i'll reply back if found)
http://exceltips.vitalnews.com/Pages...n_a_Chart.html
This might give u an idea
Hmm, not sure you need a macro. Hv a look at Andy Pope's excellent pages for
instance:
http://www.andypope.info/charts/Invertneg.htm
GL,
Henk
"Richard Flame" wrote:
>
> http://exceltips.vitalnews.com/Pages...n_a_Chart.html
>
> This might give u an idea
>
>
> --
> Richard Flame
> ------------------------------------------------------------------------
> Richard Flame's Profile: http://www.excelforum.com/member.php...o&userid=35944
> View this thread: http://www.excelforum.com/showthread...hreadid=557866
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks