Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
750
using series?
posted

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 set
2.       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                Position
7-01-2009           -232000
9-01-2009            560000
10-01-2009           -50000
12-01-2009           -70000

The ‘2000’ series:
Date                Position
7-01-2009            355000
9-01-2009            -21000 
10-01-2009           217000
12-01-2009            90000

etc..
 
Am I even approaching this correctly or is there an easier way?

Any advice would be great!

Gene

Parents
  • 750
    posted

    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?

     

Reply Children
No Data