I wanted to give the questioner the simplest way!
Merry Christmas
--
Bernard

"Jon Peltier" wrote in message
...

1) Just Copy the range, right click the chart and use Paste

Or Paste Special to gain more control over the outcome. I've always felt
this was better than drag and drop.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______