adding data series automatically
 

ok, for a project, I am trying to create a chart where once someone adds
another data series, the chart will automatically update the new series
on its own. i know how to make the chart add a new set of points
automatically into an existing series, but I am trying to get the chart
to do this as well.. here is an example of what I am talking about...
I have a chart that already has this data in it:
_Quarter_ _Sales_for_Asia_
1 2
2 5
3 7

Now say a user would like to add "Sales for Europe" the table could
look like this:
_Quarter_ _Sales_for_Asia_ _Sales_for_Europe_
1 2 3
2 5 9
3 7 6
Is there a way for the chart already in existence to add this data
series on its own, or is that impossible?
Thanks for the help


--
mbk6784
------------------------------------------------------------------------
mbk6784's Profile: http://www.excelforum.com/member.php...o&userid=35246
View this thread: http://www.excelforum.com/showthread...hreadid=550221