jmenche
06-08-2005, 07:45 PM
Hello,
I frequently analyze data with charts and have to copy the same chart over and over again...select the new range...yada yada yada.
The problem is that the ranges are not the same height (# rows).
For example:
Category Segment # of Items Dollars
Gum Fun 30 1000
Gum Fun 40 2500
Gum Fun 45 3000
Gum Mild 20 1200
Gum Mild 18 1700
Assuming that the list continues and the values for Category change...How can I create the same chart (let's say a column (dollars) and line (items) chart) for each "range"??
I have limited programming knowledge (but a good imagination). I was thinking that one way could be to loop through the list and identify and then name each range. The second part would be to loop through the ranges and create the charts.
Any help would be greatly appreciated.
I frequently analyze data with charts and have to copy the same chart over and over again...select the new range...yada yada yada.
The problem is that the ranges are not the same height (# rows).
For example:
Category Segment # of Items Dollars
Gum Fun 30 1000
Gum Fun 40 2500
Gum Fun 45 3000
Gum Mild 20 1200
Gum Mild 18 1700
Assuming that the list continues and the values for Category change...How can I create the same chart (let's say a column (dollars) and line (items) chart) for each "range"??
I have limited programming knowledge (but a good imagination). I was thinking that one way could be to loop through the list and identify and then name each range. The second part would be to loop through the ranges and create the charts.
Any help would be greatly appreciated.