I'll look into both solutions provided although the Base one kind of goes outside of the scope of what I'm looking for. This is an issue that has applied to a lot of spreadsheets for me and an auto update feature would be really useful. My spreadsheet structure is like this:
A|B|C Date|Income|Expenses YY/DD/MM|$$$$|$$$$ It seems like this wouldn't be the best for a database and seems to be perfect for a spreadsheet. Many thanks, I will be putting this into FDO as an enhancement request, I believe that MSO does it but not positive. Regards, Joel On Wed, Dec 5, 2012 at 12:12 PM, Gabriele Ponzo <[email protected]> wrote: > I forgot to Reply All, I'm sorry. > --- > Gabriele Ponzo > > > > ---------- Forwarded message ---------- > From: Gabriele Ponzo <[email protected]> > Date: 2012/12/5 > Subject: Re: [libreoffice-users] Chart Range Entire Column > To: Joel Madero <[email protected]> > > > What You seem to be looking for is an auto-scaling feature which I > don't believe has been yet implemented. > > Scientifically is correct that if you specify a range of x rows, the > graphic makes room for all af them, even if empty, because if they are > in the range, their data has to be considered (even null). > > By the way it's an interesting point of view and could be suggested as > a new feature to be added as an option for instance, I think, because > it could be useful as well. > > What I can tell You to solve this, for the moment, is to double click > into the graphic to go editing it, and then double click the Date's > axis. Now You can specify in the first Tab (Scale) the Maximum Value, > avoiding the Automatic Option. In this way it will render just the > portion of Data You'll need. > > It still requires to edit the graphic, but I think it's surely better > and faster than having to modify the Data Values Area. And I think You > could do this once a quad, leaving not too much blank space at the end > of the graphic. > > I really hope to have been useful for You and all people reading, and > also to have aimed a good solution without forgetting other ones which > could have been simpler. > --- > Gabriele Ponzo > > > 2012/12/5 Joel Madero <[email protected]>: > > Hi All, > > > > I want to know if there's a way to make a chart range be an entire column > > so that if I add data I don't have to manually alter the range. For > > instance, every month I do expenses and the new row would be "MM/YYYY" > then > > there's expenses and income listed, every time I add a new entry I have > to > > manually update the data range which is a hassle. If I select the entire > > column as a data range it automatically adjusts to the last row with > data. > > Furthermore, if I just do a range that has like 10,000 extra rows (Maybe > > A1:A10000) the chart is squished (it doesn't auto adjust according to > logic > > of where last cell contains data and then update when new data is > entered). > > > > Many thanks as always, > > Joel > > > > -- > > *Joel Madero* > > LibO QA Volunteer > > [email protected] > > > > -- > > For unsubscribe instructions 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 > > > > -- > For unsubscribe instructions 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 > > -- *Joel Madero* LibO QA Volunteer [email protected] -- For unsubscribe instructions 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
