scroll bar with check boxes
 

I have dates as x-axis values and six corresponding columns as y-axis values
(Data range- A1:G20 for example).
I am using a scatter chart and would like to create a chart with checkboxes
and a scroll bar to view data over different periods with dieffrent coulmns
checked.
The problem is the folowing:
All the examples I've seen links data ranges to offset formulas in the
namedefine box. These newly named ranges are then used as values in the
series values (x and y)boxes in the chart wizzard (or source data)
This method means that check boxes or scroll bars can be used seperately and
not simultaneously on one chart.
Any ideas?

scroll bar with check boxes
 

You could use scroll bars to configure the extent of the series (starting
and ending points), and checkboxes to handle which Y series (which worksheet
columns) are charted. Each name definition has to refer to both sets of
controls.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"wynand" wrote in message
...
I have dates as x-axis values and six corresponding columns as y-axis
values
(Data range- A1:G20 for example).
I am using a scatter chart and would like to create a chart with
checkboxes
and a scroll bar to view data over different periods with dieffrent
coulmns
checked.
The problem is the folowing:
All the examples I've seen links data ranges to offset formulas in the
namedefine box. These newly named ranges are then used as values in the
series values (x and y)boxes in the chart wizzard (or source data)
This method means that check boxes or scroll bars can be used seperately
and
not simultaneously on one chart.
Any ideas?

scroll bar with check boxes
 

any example workbooks available to illustrate your point?

"Jon Peltier" wrote:

You could use scroll bars to configure the extent of the series (starting
and ending points), and checkboxes to handle which Y series (which worksheet
columns) are charted. Each name definition has to refer to both sets of
controls.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"wynand" wrote in message
...
I have dates as x-axis values and six corresponding columns as y-axis
values
(Data range- A1:G20 for example).
I am using a scatter chart and would like to create a chart with
checkboxes
and a scroll bar to view data over different periods with dieffrent
coulmns
checked.
The problem is the folowing:
All the examples I've seen links data ranges to offset formulas in the
namedefine box. These newly named ranges are then used as values in the
series values (x and y)boxes in the chart wizzard (or source data)
This method means that check boxes or scroll bars can be used seperately
and
not simultaneously on one chart.
Any ideas?

scroll bar with check boxes
 

Nothing on hand that's not proprietary. Sorry.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"wynand" wrote in message
...
any example workbooks available to illustrate your point?

"Jon Peltier" wrote:

You could use scroll bars to configure the extent of the series (starting
and ending points), and checkboxes to handle which Y series (which
worksheet
columns) are charted. Each name definition has to refer to both sets of
controls.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"wynand" wrote in message
...
I have dates as x-axis values and six corresponding columns as y-axis
values
(Data range- A1:G20 for example).
I am using a scatter chart and would like to create a chart with
checkboxes
and a scroll bar to view data over different periods with dieffrent
coulmns
checked.
The problem is the folowing:
All the examples I've seen links data ranges to offset formulas in the
namedefine box. These newly named ranges are then used as values in
the
series values (x and y)boxes in the chart wizzard (or source data)
This method means that check boxes or scroll bars can be used
seperately
and
not simultaneously on one chart.
Any ideas?