M
mbk6784
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
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