Re: [libreoffice-users] How to make chart out of a multi-sheet ods file ?

2017-02-05 22:32 GMT+01:00 shirish शिरीष <shirishag75@gmail.com>:

> Now what I want to do is to make chart from say either page 2 or page
> 3 but unable to figure out how to do it ?

W
​hen creating a chart​, you can either prefix your intervals with
$<sheetname>. or use the button on the right of each range input then
change tab to get data from another sheet.

Additionaly, to use multiple ranges (either on the same sheet or on various
sheets) you can separate ranges using a semicolon, and/or add more data
ranges in the chart assistant.

For example, this is a multi-sheet multiple range
string: $Sheet2.$A$1:$A$7;$Sheet1.$B$1:$C$7

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