Hi Martin. It may be possible to obtain an acceptable chart using the Bar-3D -Deep type and suitably preparing your data. I don't know about turning a sheet into a formula, but you could create a macro to generate your output series. Steve
On 18/02/2020 13:13, martin f krafft wrote: > Hello folks, > > I have an elaborate sheet that essentially takes 3 different values > as input, and outputs two data series, which I can use to produce a > bar chart like so: > > ``` > | > | _ > | | | _ > | _ | | _| | > | _| | | | | | | > | | | | | |_ | | | > | | | | | | | | | | > --------------------- > ``` > > Obviously, there'll be a single formula that produces each data > point, but it'll be very complex, as the sheet currently derives the > data in multiple steps. > > What I need to do now is to graph multiple of those graphs in one. > That is, I want a 3D bar graph with the first series equivalent to > what the sheet would produce with "input" parameters (X1, Y, Z), the > second series corresponding to "input" parameters (X2, Y, Z), and so > on. > > Is this possible? Without duplicating the sheets, of course? > Essentially turn a sheet into a function/formula that I can "call"? > > Thanks for any hints, > -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
