I have a bar chart with 9 horizontal bars. The expected values for each are from -10 to +10. I want each bar to turn green if it is in the mentioned range (-10 +10) and turn red if it is not.
I am using excel 2007.
I found this post and it worked until I saved it. Excel 2007 said I could not save it in the current format (non macro) so I saved it in a macro file format. Thats when it never worked again. I have deleted all the code many times and tried to redo it and it still will not work.
I have read many of the popular pages for conditional charts and none seem to help. Can anyone offer some suggestions?
Thank you for your time and help.
I am using excel 2007.
I found this post and it worked until I saved it. Excel 2007 said I could not save it in the current format (non macro) so I saved it in a macro file format. Thats when it never worked again. I have deleted all the code many times and tried to redo it and it still will not work.
I have read many of the popular pages for conditional charts and none seem to help. Can anyone offer some suggestions?
Thank you for your time and help.