Ask Your Question
3

How can I create a chart with dynamic data series? [closed]

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

this post is marked as community wiki

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

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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-28 20:27:29.929696

Comments

OP: @Manel

manj_k gravatar imagemanj_k ( 2013-10-22 19:43:07 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2014-07-05 03:30:29 +0200

oweng gravatar image

Refer the answer here and in particular my comment beneath it.

edit flag offensive delete link more
-1

answered 2013-03-06 10:21:28 +0200

qubit gravatar image

Hi @Manel,

Still looking for an Answer to your Question?

Please post a copy of your spreadsheet so that we can take a look at what you're trying to do with Calc.

Thanks!

edit flag offensive delete link more

Question Tools

1 follower

Stats

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

Seen: 2,646 times

Last updated: Jul 05 '14