How to produce Stacked Column chart ?

Question

I'm trying to produce a Stacked Column chart

I have table data containing information thus:

Date = 22/11/2008, Payee = HCF, Amount = $75.00
Date = 22/11/2008, Payee = Misc, Amount = $20.00
Date = 22/11/2008, Payee = Rest, Amount 35.00

and many more transactions for different dates.

For the specific date, the total amount is (75 + 20 + 35) = 130.

What I'm getting is a bar showing the label of greatest amount (75.00) with
the other amounts labelled within this bar i.e. the bar contents are not additive.

How do I get each bar showing each Payee's transactions stacked one above the other?

I'm retrieving the data from a database via a LINQ query.

Answer 1

To display stacked data you need to create 3 data series and add 75, 20, 35 as data points. Here what it should look like:

Series 1 (Stacked Column)
    DataPoint 1    X=22/11/2008    Y=75 
Series 2 (Stacked Column)
    DataPoint 1    X=22/11/2008    Y=20 
Series 3 (Stacked Column)
    DataPoint 1    X=22/11/2008    Y=35 

Check Chart Sample Framework for more information...

Alex.

Answer 2

Alex: thanks. I'll follow your template.

Answer 3

Alex: thinking further about this,  I can't predict how many different Payees (Ys) there might be for any one transaction date (Xs) so I don't know how many Y data series to create. The number of Payees will vary between transaction dates. So for each X, there may be many Ys.

How would one tackle this?

In fact this will be a problem for any chart type I wish to create.

Answer 4

In order to plot the data in stacked chart you will need the data in the above format... You can either change your query or process your data after binding.

Alex.

Answer 5

Mmmm, I'll have to think about that!