anyway to copy the chart format to another worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

say you have a worksheet that has a chart based on some of the cells in the
worksheet. someone creates a brand new worksheet that includes some of the
data from the first worksheet but also has a months worth of new data. is
there anyway to easily recreate the chart format from the 1st worksheet into
the 2nd worksheet?
 
Click on the chart so that you have the small black squares in the
corners and mid points of the OUTER lines, then click <copy>, then
select your second sheet and <paste>. This copy of the chart will
still be looking at the original data, so you need to right-click on
the chart and select Source Data in order to change the references to
point to the data in your second sheet.

Hope this helps.

Pete
 
ok, thanks for the reply. I see what you mean. It didn't quite work for me
but I see the process. I think maybe the excel sheets were diffrent in some
way as well because it would not take the new ranges properly.
 

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Chart references when copying worksheets 3
Copy-Paste Chart into Word from Excel 2007 3
Cannot copy worksheet to another file 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How to use hyperlink to chart? 5
How do I transfer data from one worksheet to another? (Excel 2003) 0
Copying template from one worksheet to another 2

Back
Top