Actually I have inadevrtly said a stackedbar chart above, this should actually be a StackColumnChart.
I'm sorta getting abit further with this, I think my main problem is within the series for the stack data, I wasn;t setting a ValueColumn, look's like I need to but how do I do this for multiple values as per above table example?
Maybe I don't do this as a series, but what else is available within a composite graph. Any examples or help would be greatly appreciated.
0
Change
answered on Oct 2, 2008 1:34 AM
Question mate!
I'm grabing my data from a web service and attaching the datatable as the datasource for the stack series. Similarly with the line series.
Now I'll only have one stack series and the table form is like as follows:
With the Price columns I have actually named these as the actual price value, where the actual corresponding row value is the volume. Cause I wanna stack the actual 10 volumes and use the column headings in the legend to show what the actual price is. I did at one stage have price and volume as seperate columns but I think this way would be better.
eg. price1 column heading is actually labelled 10 (dollars)
So, how can I stack price1 thru 10 for each period and use the actual column headings in the legend.
I'll have about 6 line series layers and they are generally in the form of period, value, these will represent trend in volumes over the period and layered over the stack bar chart.
Hope this makes some sense.
This is an example of what I am trying to achieve.