I have a spreadsheet that is layed out in the following way:
Column A - Date
Column B - Name
Column C - Data1
Column D - Data2
I would like to chart the above data based on a selection within a combo box. The combo box setup is easy. How do i chart the data based on what is selected in the combo? The combo displays the Name by the way. I would like for the chart to display all rows of data corresponding to the name selected. Is this ok or is there a better way? Lend me your expertise and guidance. Thank you,
Waxaholic
Column A - Date
Column B - Name
Column C - Data1
Column D - Data2
I would like to chart the above data based on a selection within a combo box. The combo box setup is easy. How do i chart the data based on what is selected in the combo? The combo displays the Name by the way. I would like for the chart to display all rows of data corresponding to the name selected. Is this ok or is there a better way? Lend me your expertise and guidance. Thank you,
Waxaholic