Is it possible to make the columns in a bar chart change colour once the data goes above a certain value i.e. if the data is below target the column will be red, above target the column will be green.
Thanks
Is it possible to make the columns in a bar chart change colour once the data goes above a certain value i.e. if the data is below target the column will be red, above target the column will be green.
Thanks
Hi,
See Jon Peltier's example of conditional charts,
http://peltiertech.com/Excel/Charts/...nalChart1.html
Cheers
Andy
koootzz wrote:
> Is it possible to make the columns in a bar chart change colour once the
> data goes above a certain value i.e. if the data is below target the
> column will be red, above target the column will be green.
> Thanks
>
>
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks