How to copy charts without links to original
Hi, doing a lot of work with charts and often need to copy charts from one worksheet (ws A) to another (ws B) to be reused using ws B data. Excel always refers back to the original data on ws A. Is there a way to copy the charts so that the worksheet references are not copied over but just the cell references so they could immediately be reused on the new worksheet (ws B) with data in same format as original (ws A). Thanks.
How to copy row from one work sheet to another using IF
I have following data stored on Sheet 1
Service Code Speciality
AHC XXX098 Corporate
Professional Leads AXX001 Networked Community
Continuing Care AXX101 Specialist Community
On sheet 2, i have following information:
Service Req hours Filled hours %
AHC 10 5 50
Professional Leads 20 11 55
Continuing Care 25 18 72
Now, i want to cascade the data on three different spread sheets as per speciality ( Corporate, Networked Community and Speciailist Community ) by respective Service (AHC. Professional Leads and Continuing Care) with respect to the Req hours, filled hours and %.
is this possible in excel?
Hi, I am not sure if that
Hi, I am not sure if that will solve your problem, but one of the ways to quickly change "source sheet" is to right click on your chart then select "Select Data" and there you can just change name of the worksheet in "Chart Data Range". This way your new chart will use the same range as the original one, but from the new worksheet. Takes a couple of second for every chart.