Hello all,I’ve been tasked with moving some Excel code and charts into a real program and while I’ve got the raw data and calculations moved, it’s now time to show the graph.The excel chart is based on a pivot table so what I think I need to do is:1. Figure out all the distinct values of the ‘pivot column’ from the data set2. Then do a filtered query on each distinct value to generate a ‘series’3. Then add each of these series to the chart.Right?I’ve attached a picture of the chart I’m supposed to duplicate. The pivot column is the ‘1000’, ‘2000’, ‘3000’, etc… and each series from my query looks like this:The ‘1000’ series:Date Position7-01-2009 -2320009-01-2009 56000010-01-2009 -5000012-01-2009 -70000The ‘2000’ series:Date Position7-01-2009 3550009-01-2009 -21000 10-01-2009 21700012-01-2009 90000etc.. Am I even approaching this correctly or is there an easier way?Any advice would be great!Gene
it were to follow the approach that the samples use, I wouldn't use a series at all, but instead build a data table, with a column for each 'pivot' entry then populate the rows like a grid.
is that the recommended approach?
both approaches are equally valid... whether you use a DataTable or manually populate the DataPoints of each Series. i recommend choosing the one that's more convenient for you.