Chart inputs and design

[dado6612]

Hello all,
Have a table which looks like this:
in A1 is a value of 3000
in A2 is a value of 100
[TABLE="width: 206"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]X[/TD]
[TD]Y[/TD]
[TD]Side[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]55[/TD]
[TD]Z[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]55[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]115[/TD]
[TD]55[/TD]
[TD]Z[/TD]
[/TR]
[TR]
[TD]115[/TD]
[TD]55[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]205[/TD]
[TD]55[/TD]
[TD]Z[/TD]
[/TR]
[TR]
[TD]205[/TD]
[TD]55[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]2233[/TD]
[TD]75[/TD]
[TD]Z[/TD]
[/TR]
[TR]
[TD]2233[/TD]
[TD]75[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]2302[/TD]
[TD]45[/TD]
[TD]Z[/TD]
[/TR]
[TR]
[TD]2302[/TD]
[TD]45[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]2950[/TD]
[TD]50[/TD]
[TD]Z[/TD]
[/TR]
[TR]
[TD]2950[/TD]
[TD]50[/TD]
[TD]Y[/TD]
[/TR]
</tbody>[/TABLE]

How to make 2 charts where:
in first left column are values for X axis, with A1 as highest value
in middle column are values for Y axis, with A2 as highest value
in first chart only show values of Y from right column
in second chart values of Z from right column

Table size may vary for each use, so a macro if possible will do, also sadly none of data can be sorted differently.

If nothing like this is possible with the current arrangement, I'm open to suggestions.

Thanks

 

[PichaiTC]

You may add 4 more columns for 2 charts
1. Yx with formula =IF(Side = "Y", X, NA())
2. Yy with formula =IF(Side = "Y", Y, NA())
3. Zx with formula =IF(Side = "Z", X, NA())
4. Zy with formula =IF(Side = "Z", Y, NA())

then create the first chart from Yx and Yy, create the second chart from Zx and Zy.