Chart on calc with multiple sheets

asked 2017-05-28 22:10:13 +0200

giocarmine gravatar image


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?

edit retag flag offensive close merge delete


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

plgeek gravatar imageplgeek ( 2017-05-29 12:51:20 +0200 )edit

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

giocarmine gravatar imagegiocarmine ( 2017-05-29 22:47:53 +0200 )edit