Benches Uncategorized

2

Using a chart as a template

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

In Excel, I can easily take an existing chart/graph, copy and paste it into the current worksheet or even another worksheet and then open the menu for chart data to easily change the series data. This allowed all the attributes (scale, legend, font, size etc.) to stay intact. In effect, I used the first chart as a template.

As an example, I tracked my running miles for 2007 (plus 2006 and a 5-yr average for comparison) and have bar charts to show miles each month, cumulative, and miles run each year -- and yes I know this is obsessive compulsive. I started a new work sheet for 2008 with a copy and paste of the 2007 data table and adjusted the table to meet upcoming 2008 info.

And, rather than start from scratch with new charts I just want to copy and paste the old ones into the 2008 work sheet and then associate the 2008 charts with the new 2008 data on that work sheet. I can't seem to figure this out after doing searches of the forum and reading the full Numbers user manual. What was so easy to do in Excel appears to be impossible or overly complex in Numbers. Any and all help is appreciated.

Thanks ... Mark

2 replies

Sign in or join Beachball Help to reply.

  1. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    In the finder, duplicate the 2007 file and rename the duplicate >2008.

  2. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Thanks. This is somewhat helpful for my immediate example, but at work, working with a large data set, I have had cause to use the initial graph/chart based on one part of the data and use it as a template for several other sets of data on the same worksheet or even other worksheets. I'm getting the feeling Numbers lacks this feature.

    Mark