Re: [libreoffice-users] Chart Range Entire Column

On 12/05/2012 01:55 PM, Joel Madero wrote:
> 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
     Would setting up your Calc spreadsheet as a database eliminate 
this problem? Then create the chart as a report using Base as a front 
end and HSQLDB as the back  end.
     I would be curious as to the structure of your chart (columns and 
rows) to see if I could create a report for my personal financial 
database. I might even be able to add this to chapter 4 of the Base 
Guide for others.

--Dan

--
For unsubscribe instructions e-mail to: users+help@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