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. Op 23 jul. 2014, om 16:39 heeft jorge het volgende geschreven: > 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 > > > El mié, 23-07-2014 a las 10:48 +0100, Gordon Burgess-Parker escribió: >> 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! >> >> >> > > -- > Atentamente, > > Jorge Rodríguez > > > -- > To unsubscribe e-mail to: [email protected] > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
