Bar graph colour changes
I have an excel pareto bar graph. The values are linked to another workbook &
will change daily. I want different values to be different colours by selected group, i.e. top value may be yellow, next 2 values red, but next day the top value (yellow) may now be 2nd value but needs to stay yellow. This can be done manually each day, but I wonder can it be done automatically by adding another value to the source data. 1=yellow, 2=red etc. Any help will be gratefully appreciated |
Bar graph colour changes
Hi,
Have a look at Jon's page(s) on conditional charts. http://peltiertech.com/Excel/Charts/...nalChart1.html VBA maybe another approach you could use. Cheers Andy Baldyman wrote: I have an excel pareto bar graph. The values are linked to another workbook & will change daily. I want different values to be different colours by selected group, i.e. top value may be yellow, next 2 values red, but next day the top value (yellow) may now be 2nd value but needs to stay yellow. This can be done manually each day, but I wonder can it be done automatically by adding another value to the source data. 1=yellow, 2=red etc. Any help will be gratefully appreciated |
Bar graph colour changes
Thanks for the idea, I may have to try VBA as the data that will control each
colour won't be appearing as part of the graph. "Andy Pope" wrote: Hi, Have a look at Jon's page(s) on conditional charts. http://peltiertech.com/Excel/Charts/...nalChart1.html VBA maybe another approach you could use. Cheers Andy Baldyman wrote: I have an excel pareto bar graph. The values are linked to another workbook & will change daily. I want different values to be different colours by selected group, i.e. top value may be yellow, next 2 values red, but next day the top value (yellow) may now be 2nd value but needs to stay yellow. This can be done manually each day, but I wonder can it be done automatically by adding another value to the source data. 1=yellow, 2=red etc. Any help will be gratefully appreciated |
All times are GMT +1. The time now is 10:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com