I know i'm digging up an old thread, but for the sake of those like me who ended up on this thread (3 years later) I am posting my SOLUTION for you
I'm using Apache OO 4.1.2 and disappointingly this issue it still present
.I have found a work-around.
Apparently all the Y values are present in the writer-copied chart data (not displayed in the graph), BUT!, the categories are not. This is a formatting issue. wattlecottage hit the nail on the head - but i did not understand his instruction - hahah
I can confirm that renaming the worksheet does the trick, but then had a problem with the x axis scale converting numbers to dates. If you turn off 'source format' under Numbers in the Format Axis box and format the axis in there it will get around the problem.
There are three things you can do which work around this copy issue:
#1. Format your data series labels (categories or x and y axis labels) to text or numbers only
(%, dates, times etc. seem not to work) (that is the format of the data in the cells where your labels come from not the graph axis titles.
#2. Read this bug report thread and use its work-around https://bugs.documentfoundation.org/show_bug.cgi?id=71767
#3. follow wattlecottage's solution if you can find the checkbox for 'source format' - i could not.
Hope this helps until those really nice, kind, clever developers fix the formatting issue.
Oh, and, I did not add this to the bugreport - so if anyone is up to it, please do me the favour.