Group by Label
Posted: Wed Sep 01, 2010 10:46 am
Hello - this must have come up before but my searches aren't finding an answer.
I have a set of data in the form
Company 1, 500
Company 2, 250
Company 1, 300
Company 3, 125
Company 2, 400
Company 3, 200
etc
If I add these to a series using SomeBarSeries.Add(Value, CompanyName) I end up with a point per entry - I actually want them aggregated (grouped) by their Label. So all the values for each company get added together, and I get one bar per company.
The order is random. Is there a quick way that I can set a Series to automatically do this, or do I need to group the data myself and then add it?
Thanks
Richard
I have a set of data in the form
Company 1, 500
Company 2, 250
Company 1, 300
Company 3, 125
Company 2, 400
Company 3, 200
etc
If I add these to a series using SomeBarSeries.Add(Value, CompanyName) I end up with a point per entry - I actually want them aggregated (grouped) by their Label. So all the values for each company get added together, and I get one bar per company.
The order is random. Is there a quick way that I can set a Series to automatically do this, or do I need to group the data myself and then add it?
Thanks
Richard