|
|
Copy charts in Numbers?
|
|
|
|
Addicted to MacNN
Join Date: Mar 2006
Status:
Offline
|
|
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!
|
|
|
|
|
|
|
|
|
Addicted to MacNN
Join Date: Jun 1999
Location: Las Vegas, NV, USA
Status:
Offline
|
|
I'm confused by your question. You have charts in table rows?
|
|
|
|
|
|
|
|
|
Addicted to MacNN
Join Date: Mar 2006
Status:
Offline
|
|
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!
|
|
|
|
|
|
|
|
|
Addicted to MacNN
Join Date: Jun 1999
Location: Las Vegas, NV, USA
Status:
Offline
|
|
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
|
|
|
|
|
|
|
|
|
Dedicated MacNNer
Join Date: Mar 2003
Status:
Offline
|
|
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
|
|
|
|
|
|
|
|
|
Addicted to MacNN
Join Date: Mar 2006
Status:
Offline
|
|
Thanks, that kind of sucks, appreciate the advice though.
|
|
|
|
|
|
|
|
|
Addicted to MacNN
Join Date: Mar 2006
Status:
Offline
|
|
Does anyone know whether Excel or OOO can do this any more easily? Thanks!
|
|
|
|
|
|
|
|
|
Dedicated MacNNer
Join Date: Mar 2003
Status:
Offline
|
|
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
|
|
|
|
|
|
|
|
|
Addicted to MacNN
Join Date: Mar 2006
Status:
Offline
|
|
Great to know. Thanks. Sucks that Numbers won't do that.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Forum Rules
|
|
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
|
HTML code is Off
|
|
|
|
|
|
|
|
|
|
|
|