siddharthnk
New Member
- Joined
- Jun 20, 2013
- Messages
- 48
I have two stacked bar graphs which are adjacent to each other horizontally on the same worksheet. Below these graphs I have represented the data is a tabular format. The data in concern is sales numbers for 6 sectors on a weekly basis. The first graph and the table below it has data as per a particular technology for six sectors and the adjacent graph and table below it has data as per another technology.
The worksheet is called graph sheet. The data for both the graphs and the tables is derived from data on another worksheet called graph data.
The graphs need to be placed next to each other as per specifications and since the graphs are next to each other and the respective tables below them, they are running out of horizontal space.
It would be great if you could help me constructing a scrolling stacked chart and a scrolling table so that I can insert a scroll bar between the chart and the table below it. When the user drags the scroll bar to the right, the data in the chart and the table scroll to the left.
Appreciate your help in advance.
The worksheet is called graph sheet. The data for both the graphs and the tables is derived from data on another worksheet called graph data.
The graphs need to be placed next to each other as per specifications and since the graphs are next to each other and the respective tables below them, they are running out of horizontal space.
It would be great if you could help me constructing a scrolling stacked chart and a scrolling table so that I can insert a scroll bar between the chart and the table below it. When the user drags the scroll bar to the right, the data in the chart and the table scroll to the left.
Appreciate your help in advance.
