Parametrising sheets

users
#1

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:

```

#2

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

#3

Regarding the following, written by "Steve Edmonds" on 2020-02-18 at 14:17 Uhr +1300:

I don't know about turning a sheet into a formula, but you could create a macro to generate your output series.

That sounds ugly, but yes, that could work. But I was really trying to avoid that, and still hope I can!

Thanks for your response!

#4

Hi Martin.
Do Y and Z stay the same and just x varies (as input).
How many input values of x would you want process and display in one chart.

Steve

#5

Regarding the following, written by "Steve Edmonds" on 2020-02-18 at 15:06 Uhr +1300:

Do Y and Z stay the same and just x varies (as input).

For this one graph, yes. I'd probably also want to make other graphs with Y and Z varying.

How many input values of x would you want process and display in one chart.

Between 5 and 15. But more would be better, to be honest, and hence the desire to parametrise, rather than to hack this up with macros, or using copy-paste.

#6

I am wondering if LO will be the solution that works best for you.
What is the format of the output series (columns, length, positional or
x/y/z).
If you create output from 15 input variations, I assume that is 30
series. Can you simulate these and get Calc to chart them as you wish.
This will at least determine if LO is viable for your use.
steve