Welcome to the MacNN Forums.

I have a data table, and I want one chart per row, with about 30 rows. I can't figure out how to copy a chart, so that I can get the same settup, formatting etc, just applied to one line down on the table.
Any ideas? Thanks!

I'm confused by your question. You have charts in table rows?

I have 30 rows, and one chart, that corresponds to row 1.
I want to copy the formatting of the chart so that I have the same size, prefs, axis settings etc for 29 more charts all the way down the page.
Thanks!

I see now. This is speculation, but try it:

1. Copy the chart 30 times so you have all of the charts you need. The copies should have the same formatting, no?

2. The trick, then, is to go down your charts and replace the data series in each chart with the next row. Numbers help tells you how to replace a data series. Search for "replace a data series":

To replace a data series:
- Select the chart.
- Select the series you want to move, either by clicking the data series in the chart or by clicking the data series label in the table.
- Drag the data series in the table to the row or column you want to use as a replacement.

Chris

Had the same issue too

I think there's currently no way to copy a chart and then re-link it to another data table.

So, Chris probably has the only solution - copy the finished chart along with its linked table (should be automatic actually), paste it onto your target sheet and then edit the attached table with your data.

Send a feature request to Apple! I've done that

Thanks, that kind of sucks, appreciate the advice though.

Does anyone know whether Excel or OOO can do this any more easily? Thanks!

Apparently works great in Excel 2004:

I created two similar but separate tables and a chart linked to the first. After copying the chart, I was able to change the data series to link the copy to the second table. The formatting remained the same as before. Just drag and drop!

Hi Apple

Great to know. Thanks. Sucks that Numbers won't do that.