Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Copying data from one chart to another - how?
I have many graphs - all plotting on similar scales but using different data. Is there any way I can simply copy one set of data from one graph and paste it into another graph so that I can avoind going through all the hassle plotting each curve again? I want to have graphs showing different combinations of the same data and have hundreds of curves to plot so this could be a huge timesaver... Cheers. -- Alan_Partridge ------------------------------------------------------------------------ Alan_Partridge's Profile: http://www.excelforum.com/member.php...o&userid=29295 View this thread: http://www.excelforum.com/showthread...hreadid=490106 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Copying data from one chart to another - how?
This might help. Select the series you want to copy, then select the SERIES
formula in the formula bar, and copy that. Select the other chart's plot area, and paste. This creates a new series in the second chart that is based on the formula. You can copy a chart, then select another chart, and use Paste Special from the Edit menu. This allows you to paste either the formats or the formulas from the first chart onto the second. This pastes all the series, not just one at a time as the first technique does. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Alan_Partridge" <Alan_Partridge.1zes0n_1133520002.5758@excelforu m-nospam.com wrote in message news:Alan_Partridge.1zes0n_1133520002.5758@excelfo rum-nospam.com... I have many graphs - all plotting on similar scales but using different data. Is there any way I can simply copy one set of data from one graph and paste it into another graph so that I can avoind going through all the hassle plotting each curve again? I want to have graphs showing different combinations of the same data and have hundreds of curves to plot so this could be a huge timesaver... Cheers. -- Alan_Partridge ------------------------------------------------------------------------ Alan_Partridge's Profile: http://www.excelforum.com/member.php...o&userid=29295 View this thread: http://www.excelforum.com/showthread...hreadid=490106 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How To: Link worksheet data to pre-existing chart tables | Excel Worksheet Functions | |||
Activating a Chart object | Charts and Charting in Excel | |||
Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |