Diagram - group by

[Jorgensen]

I have an table that looks like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Group 1[/TD]
[TD]Subject A[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Group 1[/TD]
[TD]Subject B[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Group 1[/TD]
[TD]Subject C[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Group 1[/TD]
[TD]Subject D[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Group 2[/TD]
[TD]Subject E[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Group 2[/TD]
[TD]Subject G[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Group 2[/TD]
[TD]Subject Z[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Group 2[/TD]
[TD]Subject Y[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]

i can't figure out how to create a diagram, that groups the data via the Group column / and i don't know if it's possible at all :-/

it seems i can't insert images from dropbox so i had to add a link
but here is a sketch that shows what i'm trying to achieve
https://www.dropbox.com/s/7hef1hhv2q5ecez/Capture.PNG?dl=0

thanks
jorgensen

 

[Jorgensen]

hi

just to followup my posts.

i did manage to create some usefull diagrams - thanks to all.

regarding books
i have just purchased this small ebook by Roger F. Silva and it seems ok
http://www.amazon.com/Create-Learn-...?ie=UTF8&redirect=true&ref_=kinw_myk_ro_title

thanks
jorgensen