Chart on calc with multiple sheets

[giocarmine]

Hello,

would like to make a chart in Calc. This is what i need to do:

• there are several sheets in the document, more will be added
• every sheet contains some cell values that i want to graph, for every sheet i need a group in the chart
• a separate sheet would hold only the graph
• every time a sheet is added the graph should update automatically

Basically i want something like this

link text

is there a way to do this?

[plgeek]

elaborate on this please as its not clear what you would like to achieve…

[giocarmine]

i need exactly a graph like the one in the link, every sheet is a “group” and every group has different values