Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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:

image description

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

image description

Selecting Next bring up this dialog:

image description

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:

image description

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:

image description

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

image description

Selecting Next bring up this dialog:

image description

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:

image description

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.