Error When Using Multiple Columns From Multiple Sheets as Chart Dataset


I am using onlyoffice integration with nextcloud. I am on the latest version of office server 7.4 and nextcloud integration 8.1.

I have a spreadsheet of my finances over several year. Each year is in its own worksheet for better separation. I then have a worksheet where I do calculations on all the data in those sheets. The problem I am facing is I can’t seem to get charts to show data across the across the same row in multiple sheets using this: Year2019:Year2020!B34:M34. It works great when in formulas, but if I set it has a dataset in a chart onlyoffice throws an error and acts real weird.

Hello @marcs

Please try adding the values this way:


Also you can do this manually by tapping Select Data button and selecting required range from each sheet while holding CTRL button.

Let me know if it helps.

Doing this, Year2019!$A$1:$A$2,Year2020!$A$1:$A$2, just puts each sheet on its own line. Not in one continuous line, which is what I am looking for.


Got it, you should’ve mentioned that straight away.
You must have only one legend series and ranges in the series should be in brackets:


Result and example:

That worked thank you.
Sorry language is hard, couldn’t really figure out how best to explain that nor how to look up any documentation on it.

1 Like

Don’t worry, it’s ok.
I’m glad we found what you needed.