I would like to control a chart on my screen by using a combo box selection. As I am new to vba I would like to know how i can use the chart object through code.
I want the row source based on the combo selection. So each time I change the data selection the graph would refresh based on the selection.
Any help would be great appreciated.