I forgot to Reply All, I'm sorry. --- Gabriele Ponzo
---------- Forwarded message ---------- From: Gabriele Ponzo <gpo...@gmail.com> Date: 2012/12/5 Subject: Re: [libreoffice-users] Chart Range Entire Column To: Joel Madero <jmadero....@gmail.com> 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 <jmadero....@gmail.com>: > 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 > jmadero....@gmail.com > > -- > For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org > 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: users+h...@global.libreoffice.org 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