Hi,
I am facing a problem in excel charting. The chart is created based on the datas of Colum Q&R ColQ is X axis. my chart is created based on the data of Details "A" that is col R ( Y Axis) I have a validation list in cell N5, A,B,C,D,E etc
What I would require is , if I select B, then the chart has to be updated based on ColS, If C is selected then Y axix data should be updated as ColT and so on.
I have attached my excel file for your reference.
Thanks in advance for your help
Arvind
Bookmarks