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

X	Y	Side
25	55	Z
25	55	Y
115	55	Z
115	55	Y
205	55	Z
205	55	Y
2233	75	Z
2233	75	Y
2302	45	Z
2302	45	Y
2950	50	Z
2950	50	Y

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>

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.