Charts: scroll bar and 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? |
All times are GMT +1. The time now is 10:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com