Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charts: scroll bar and check boxes | Excel Discussion (Misc queries) | |||
How do I increase the size of check in check boxes | Excel Discussion (Misc queries) | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) | |||
adding scroll bar to comment boxes | Excel Discussion (Misc queries) |