I do this all the time by selecting the entire chart using the little plus sign on the top right and then using ctrl c and ctrl v. This isn't working for you?
So do I. But this is not a chart. It's clumsily made using Columns.
Basically the document has four columns (not a table), something like this:
![](http://i.imgur.com/wkxsKcd.png)
So the data is not even typed in in the right order (ie: it goes down, and then back to the top for the second column, instead of going across one row at a time).