I have checked the forum and I have found it can be done.
eg: http://www.excelforum.com/excel-char...d-on-rule.html
But i'm sorry to say that i do not understand the code for making a chart. I've found that the range of selection of chart can be change but i do not know how to do so. Please can anyone explain to me how to get that chart?
Attached please find the sample excel for my problem.
Thank you so much!
Bookmarks