On Mon, Jan 14, 2013 at 9:54 PM, Andreas Guelzow <aguel...@pyrshep.ca> wrote:
> On Mon, 2013-01-14 at 17:40 -0800, Per wrote:
>> Hi,
>> I have 20 identical sheet, each containing data obtaining in one
>> experiment. For one sheet, I have generated a chart with 10+ series
>> with error bars. When I copy this chart to another sheet, the data
>> sources are copied along with it. I want, however, the chart to use
>> the data in the same sheet (but same rows and columns).
>>
>> How can I copy a chart but have Gnumeric 'forget' which sheet the
>> graph was copied from and instead use the data in the current sheet
>> only?
>>
>
> I you specify an address for the data in a chart series A1:A10 then
> Gnumeric uses this as a a fixed range on the sheet the graph is located.
> If you move or copy the graph it will remain attached to the original
> range, as you observed. Often this is exactly the desired behaviour.
This did not work as intended in Gnumeric 1.10.17, which is the most
recent from the Ubuntu 12.10 repositories. A1:A10 is automatically
changed to 'SHEETNAME'!$A$1:$A$10.
> For you use case you can use a formula to obtain the data, ie.
> INDIRECT("A1:A10"). That is also being evaluated on the current sheet.
> So copying your chart will use the data from the current sheet.
Using the INDIRECT function to get the data from the current sheet
indeed worked. This will do just fine.
> You need a pretty recent version of Gnumeric for this to work. (I think
> 1.11.2 or later.)
Thank you,
Per Knutsen
_______________________________________________
gnumeric-list mailing list
gnumeric-list@gnome.org
https://mail.gnome.org/mailman/listinfo/gnumeric-list
