Ask Your Question

Calc "chart update" [closed]

asked 2012-03-05 09:30:44 +0200

mkrmec gravatar image

updated 2012-03-05 11:01:10 +0200

I have a chart that has a data range of 1000+ columns.

At start all of them are empty. Gradually when we enter data, I would like that the chart is auto updated with just the "available data" and not "available data + all the empty ones as "0"".

I would like to know how I would go about doing that.

EDIT I just saw that the only thing not updating is the X axis. It's not adding the space for new Y values. Sooo... how do I fix this?

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 2015-10-15 05:56:48.501883

2 Answers

Sort by » oldest newest most voted

answered 2012-03-05 12:57:55 +0200

Pedro gravatar image

The problem with your chart is that you didn't define an X range. Since you are using an XY Plot and no range is defined for the X axis, Calc (wisely) uses the column number as the X category.

In this particular case you should use cells E1 to AMF1 (assuming Datum means Date) as the X-axis.

edit flag offensive delete link more


I'll check it out, thank you.

mkrmec gravatar imagemkrmec ( 2012-03-05 13:22:21 +0200 )edit

answered 2012-03-05 11:19:06 +0200

Pedro gravatar image

updated 2012-03-05 11:19:19 +0200

Can you provide a link to an example file? The problems probably depend on the type of chart and organization of the data...

edit flag offensive delete link more


I marked the range on the second sheet... change it, so it works hehe :D thank you

mkrmec gravatar imagemkrmec ( 2012-03-05 12:10:09 +0200 )edit

Question Tools


Asked: 2012-03-05 09:30:44 +0200

Seen: 2,400 times

Last updated: Mar 05 '12