Selectively Displaying a Data Series on a Chart

[Geronimo]

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.]

Either way

 

[Geronimo]

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

 

[Mark W.]

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]

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

 

[Mark W.]

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]

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.]

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]

I'm not quite sure what you mean.

 

[Mark W.]

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