Columns change colour with value
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 -- koootzz ------------------------------------------------------------------------ koootzz's Profile: http://www.excelforum.com/member.php...o&userid=30982 View this thread: http://www.excelforum.com/showthread...hreadid=506495 |
Columns change colour with value
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 |
All times are GMT +1. The time now is 11:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com