Selectively Displaying a Data Series on a Chart

Geronimo · Apr 9th, 2002, 04:33 PM

I have a spreadsheet which has 5 columns of data in columns B thru F in rows 3 thru 33. I wish to construct a chart with a combo box from which I can select any of the 5 columns of data, or all 5 columns, as a Data Series to display on the chart. Is it best to use a formula or VBA? Please advise!! Thank you for your kind attention & help! I appreciate it.

[ This Message was edited by: Geronimo on 2002-04-09 15:33 ]

Mark W. · Apr 9th, 2002, 04:46 PM

Either way

Geronimo · Apr 9th, 2002, 04:52 PM

I guess I was not clear enough. Is there a formula that will do the job & what is it. Thanks

Mark W. · Apr 9th, 2002, 04:54 PM

Quote:

On 2002-04-09 15:52, Geronimo wrote:
I guess I was not clear enough. Is there a formula that will do the job & what is it. Thanks

What's the value that your combo box will produce? What kind of chart?

[ This Message was edited by: Mark W. on 2002-04-09 15:55 ]

Geronimo · Apr 9th, 2002, 05:01 PM

I wish to use a line chart plotting numerical values from the columns against days of the month in the rows.

Mark W. · Apr 9th, 2002, 05:04 PM

Quote:

On 2002-04-09 16:01, Geronimo wrote:
I wish to use a line chart plotting numerical values from the columns against days of the month in the rows.

You had better supply some sample data... And, what's the value that your combo box will produce?

Geronimo · Apr 9th, 2002, 05:18 PM

Date Morning Afternoon Evening Night
4/1/2002 124.0 126.0 119.0 177.0

4/2/2002 137.0 117.0 140.0 175.0
4/3/2002 118.0 112.0 106.0 199.0
4/4/2002 115.0 145.0 131.0 167.0
4/5/2002 112.0 114.0 136.0 192.0
4/6/2002 134.0 113.0 116.0 167.0
4/7/2002 84.0 82.0 111.0 184.0

Here is a small section of the spreadsheet. I want to choose from a combo box on the chart any one or all of the column headings & display the numerical data on a line chart.One axis has the column headings & the other the day of the month, 1 or 2, or 3 etc.

[ This Message was edited by: Geronimo on 2002-04-09 16:21 ]

Mark W. · Apr 9th, 2002, 05:25 PM

What's the contents of the Combo Box's input range and what is its cell link?

[ This Message was edited by: Mark W. on 2002-04-09 16:27 ]

Geronimo · Apr 9th, 2002, 05:28 PM

I'm not quite sure what you mean.

Mark W. · Apr 9th, 2002, 05:33 PM

See the Excel Help Index topic for "About control properties for list boxes and combo boxes".

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

Apr 9th, 2002, 04:33 PM	#1
Geronimo New Member Join Date: Mar 2002 Location: Toledo, OH Posts: 18	I have a spreadsheet which has 5 columns of data in columns B thru F in rows 3 thru 33. I wish to construct a chart with a combo box from which I can select any of the 5 columns of data, or all 5 columns, as a Data Series to display on the chart. Is it best to use a formula or VBA? Please advise!! Thank you for your kind attention & help! I appreciate it. [ This Message was edited by: Geronimo on 2002-04-09 15:33 ]

Apr 9th, 2002, 04:46 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Either way

Apr 9th, 2002, 04:52 PM	#3
Geronimo New Member Join Date: Mar 2002 Location: Toledo, OH Posts: 18	I guess I was not clear enough. Is there a formula that will do the job & what is it. Thanks

Apr 9th, 2002, 05:01 PM	#5
Geronimo New Member Join Date: Mar 2002 Location: Toledo, OH Posts: 18	I wish to use a line chart plotting numerical values from the columns against days of the month in the rows.

Apr 9th, 2002, 05:18 PM	#7
Geronimo New Member Join Date: Mar 2002 Location: Toledo, OH Posts: 18	Date Morning Afternoon Evening Night 4/1/2002 124.0 126.0 119.0 177.0 4/2/2002 137.0 117.0 140.0 175.0 4/3/2002 118.0 112.0 106.0 199.0 4/4/2002 115.0 145.0 131.0 167.0 4/5/2002 112.0 114.0 136.0 192.0 4/6/2002 134.0 113.0 116.0 167.0 4/7/2002 84.0 82.0 111.0 184.0 Here is a small section of the spreadsheet. I want to choose from a combo box on the chart any one or all of the column headings & display the numerical data on a line chart.One axis has the column headings & the other the day of the month, 1 or 2, or 3 etc. [ This Message was edited by: Geronimo on 2002-04-09 16:21 ]

Apr 9th, 2002, 05:25 PM	#8
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	What's the contents of the Combo Box's input range and what is its cell link? [ This Message was edited by: Mark W. on 2002-04-09 16:27 ]

Apr 9th, 2002, 05:28 PM	#9
Geronimo New Member Join Date: Mar 2002 Location: Toledo, OH Posts: 18	I'm not quite sure what you mean.

Apr 9th, 2002, 05:33 PM	#10
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	See the Excel Help Index topic for "About control properties for list boxes and combo boxes".