Re: Copy chart between sheets

On Mon, Jan 14, 2013 at 9:54 PM, Andreas Guelzow <aguelzow pyrshep ca> wrote:
On Mon, 2013-01-14 at 17:40 -0800, Per wrote:
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

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

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]