Copy Data From Chart to Chart

K

Karen

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
 

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

Similar Threads

Creating a Chart on form from selected data in query. 0
Employee Schedule not plotting properly - chart type / data series not correct 0
Consolidation Table from Different Excel Tabs with Different Format 1
Bar Chart with Data Elements 1
Possible to Combine reports to's to a single box? 0
Copy Data From Chart to Chart 4
Copy Data From Chart to Chart 0
Chart SERIES OFFSET 5

Top