Multiple stacked column graph

[ianh]

I'm not sure how to go about this and not sure if my data set is in the best format.

I would like to have a group of stacked bar graphs for each row (relating a to a student) where a group of columns in the table relate to the vaules to make up each subject (start point, current level, target level)

Attached is an example of what i get as well as an example of how i would like it to look.

[ianh]

i'm guessing by the number of views this has had and no response i've either not been very clear or this cannot be done.

Essentialy i want two or more stacked column bars with their data being populated by coumns f,g,h for bar one and then bar two being poopulated by numbers in m,n,o. each row will have its own graph.

I've tried transposing the data but still cant get the desired effect. is there some other layout/format i can try? Could the data be read from XML into somekind of graph to avoid a problem with the layout?

[ianh]

Bump,

Still no joy on this then

[Andy Pope]

similar to your other thread you will need to calculate the looked up values.

[ianh]

Thanks for the example andy.

quite clearly i hadn't thought that through very well and had convinced myself it was much harder than it needed to be.