# Revision history [back]

Hello,

First, all credit for the answer goes to @pierre-yves samyn. I just wanted to post a sample based upon his answer and show you that it answers you question.

First the Calc file:

Then following the instructions in his provided link you will get to this point where I select Data Series in Rows & not Columns:

Selecting Next bring up this dialog:

Now under Data Series you can remove all but the one line you wish to retain. This will give you the chart for single line you are looking for:

Using this method I created four different charts on different pages in one writer file all based upon a single linked table to the Calc file. If you want, you could just repeat this process in different Writer documents.

Hello,

First, all credit for the answer goes to @pierre-yves samyn. I just wanted to post a sample based upon his answer and show you that it answers you your question.

First the Calc file:

Then following the instructions in his provided link you will get to this point where I select Data Series in Rows & not Columns:

Selecting Next bring up this dialog:

Now under Data Series you can remove all but the one line you wish to retain. This will give you the chart for single line you are looking for:

Using this method I created four different charts on different pages in one writer file all based upon a single linked table to the Calc file. If you want, you could just repeat this process in different Writer documents.