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

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/
_______

Karen wrote:

> 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
>

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

In article <DC347DCE-430D-4FD6-B259-(E-Mail Removed)>,
(E-Mail Removed) says...
>
> 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â¤=3Fm using Excel 2000
> Thank you
>
>

"Karen" <(E-Mail Removed)> wrote in message news:<DC347DCE-430D-4FD6-B259-(E-Mail Removed)>...
> 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

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/
_______

Eva Whitley wrote:

> "Karen" <(E-Mail Removed)> wrote in message news:<DC347DCE-430D-4FD6-B259-(E-Mail Removed)>...
>
>>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