Chart data

users
#1

Hi!
I'm trying to create a chart where when I add data I don't have to edit the data range each time to include the new row.
I can't see how to do that. (Probably something I've missed).
Can anyone help?

Ta!

#2

You are not missing anything, this has always been an OOo/LO/AOO limitation.

As usual there is a workaround though :slight_smile:

See Comment 2 on this Enhancement request

https://bugs.freedesktop.org/show_bug.cgi?id=66250

#3

Hi:

I could suggest you to select a greatter range than you are going to use
at the begining. For example. Imagine you need make a chart with the
information of all the months of the year but at this moment you have
only seven mounth, like this:

Row A B

1 J 10
2 F 20
3 M 30
4 A 40
5 My 40
6 J 50
7 Jy 60

But you expect five additional months:

Row A B

8 A ? (Keep in blank)
9 S ? (Keep in blank)
10 O ? (Keep in blank)
11 N ? (Keep in blank)
12 D ? (Keep in blank)

When you select the initial range you can select:

A1:B12 as complete series

In this case the chart only show elements graphics for months that have
numbers...the others only by referens...but if you dont want show these
in the chart you can hide its part of range-rows-(Partial or Total), and
the chart adjusts automatically its range.

I hope this help you to make your chart better and easier,

Regards,

Jorge Rodríguez

#4

In MS Excel one can select a full column by just leaving off the rownumber, example: MAX(B:B).
If I open the .xls file with LibreOffice this formula gets translated in MAX(B$1:B$983040)

Tried to enter the original formal but that responds #NAME?.
Apparently LibreOffice does not have the functionality.

Rob.

#5

Hi:

  I'm sorry for you but LO is quite different to excel not all that you
can do in LO you can do in excel and invece ... They usually do almost
all but in different way...sometimes one or other improve process that
the other doesn't do by different issues. Is like a car, if you change a
car you can't expect its perfomance is equal to other car.

  I tried to give you a way to solve your problem using LO Car !

Regards,

Jorge Rodriguez

#6

Hi :slight_smile:
I think you give good answers. We can't always solve everyone's
questions. Hopefully we do push enough of them in the right direction but
it is not always possible.

There are other places people can use to try to find answers too. Also we
are not just about giving answers but are also about showing people that
this is a comfortable place to "mull over issues" and to maybe pick up some
new ways of thinking. Those new ways might help people with other
problems.

Sometimes problems only get solved when several people ask because it takes
time for us to learn how to cope with something new. Sometimes the
functionality is not there yet so we push for new features. Sometimes it's
something that is not widely known about so we all learn.

So, don't worry when you can't help a person directly. Just trying to help
shows them that they are not alone and that can be a huge help.

Good work! Much appreciated :slight_smile:
Regards from
Tom :slight_smile:

#7

Hi Tom:

  Thank you by your words

Regards,

Jorge Rodríguez