Copy Data from Chart to Chart

G

Guest

I have to create separate charts for ten employees. I want to have all the data on one sheet tab. Create the chart on another tab for employee 1, format the chart the way I want and be able to add the data for employee 2, 3, 4, etc. to each tab, using the same format for chart 1 so they all match. So there should be one tab for raw data and 10 tabs for each employee. I’m using Excel 2000
Thank you
 
J

Jon Peltier

Karen -

Make a chart for the first employee, and make it look just the way you
want it. Then right click on the sheet tab, select Move or Copy, and
make a copy. Then make eight more copies. Right click on a copied sheet,
select Source Date, click on the Series tab, and click in the box with
the range for the Values. This brings you to the data sheet, so just
select the appropriate range for the data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
T

Tushar Mehta

You may also want to create only one chart and use a drop down box to
select which employee's data are shown. For an example, see the
Excel/Tutorials/Dynamic Charts page of my web site, especially examples
4 and 6.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
E

Eva Whitley

Karen said:
I have to create separate charts for ten employees. I want to have
all the >data on one sheet tab. Create the chart on another tab for
employee 1, format >the chart the way I want and be able to add the
data for employee 2, 3, 4, >etc. to each tab, using the same format
for chart 1 so they all match. So >there should be one tab for raw
data and 10 tabs for each employee. I’m using >Excel 2000
Thank you

I don't even pretend to be operating in the same leagues as some of
the folks here but would it work to highlight the data for the first
employee, hit F11 (assuming you want to default chart type), then
format the chart the way you want, highlight the data for the second
employee, hit F11, and so on, and then copy the first chart and do a
Paste Special>Format for each chart?--Eva Whitley
 
J

Jon Peltier

Eva -

I often use this technique; it's pretty handy. The drawback is that any
text in the chart title or axis titles (and I think data labels, but I
don't remember) of the copied chart overwrite their counterparts in the
chart it's pasted into.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top