Create a chart with dynamic data series [updated]

asked 2012-06-27 14:05:21 +0200

This post is a wiki. Anyone with karma >750 is welcome to improve it.

updated 2012-06-29 16:47:55 +0200

Manel
11 ● 1 ● 4

I am looking for a way to create a dynamic chart in Calc, so that it automatically increases or decreases the rows evaluated depending on the number of rows populated in my source data sheet. This source data sheet may change regularly - i.e. one week it may contain 50 rows; the next week 125 rows and so on.

I've tried: - Define a Name with a range. The range can be changed with a macro, but i've not found the way for call that name inside the chart. - Modify with a macro the range of the series but i only can change the range of one of the series.

Anyone can help me please?

{UPDATE} OK, now I have a chart that automatically increases or decreases the rows evaluated depending on the number of rows populated in a pivot table. Now the problem is that some data in the pivot table isn't show because is repeated. Is there any way to show repeated data in a pivot table?

Thank you