Chart data via a Combo Box?

Waxaholic · Apr 3rd, 2002, 04:13 PM

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

Dave Hawley · Apr 3rd, 2002, 08:12 PM

Hi Waxaholic

Have a look here:
http://www.ozgrid.com/download/default.htm

Under:
ChangingCombo.zip
ChangingCombo2.zip
ChartByMonth.zip

I think you will find some functions there you could adapt.

Waxaholic · Apr 4th, 2002, 10:06 AM

Thank you. That should work just fine. I had tried your "Changing Range Chart" prior to posting this and liked it alot. It will come in handy.

Waxaholic

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 3rd, 2002, 04:13 PM	#1
Waxaholic Board Regular Join Date: Apr 2002 Posts: 68	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

Apr 3rd, 2002, 08:12 PM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Waxaholic Have a look here: http://www.ozgrid.com/download/default.htm Under: ChangingCombo.zip ChangingCombo2.zip ChartByMonth.zip I think you will find some functions there you could adapt.

Apr 4th, 2002, 10:06 AM	#3
Waxaholic Board Regular Join Date: Apr 2002 Posts: 68	Thank you. That should work just fine. I had tried your "Changing Range Chart" prior to posting this and liked it alot. It will come in handy. Waxaholic