Error When Using Multiple Columns From Multiple Sheets as Chart Dataset

[marcs]

Hello,

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.

[Constantine]

Hello @marcs

Please try adding the values this way:

Sheet1!$A$1:$A$2,Sheet1!$A$1:$A$2

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.

[marcs]

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.

[Constantine]

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:

=(Sheet1!$A$1:$C$1,Sheet2!$A$1:$C$1)

Result and example:

[marcs]

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.

[Constantine]

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