dynamic chart from subset of pivot table

[MartinL]

I have a pivot table that needs a chart from part of it (My Brand).
The pivot table is made up of Market data and my brand data where the result shows %Of.

This means that if I attempt to hide market data the whole thing collapses.

I just want the chart to Show my Brand %Of figures and due to the dynamic nature of the thing I do not see how I can use a helper table.

Can anyone help

Sheet1

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

BRAND

Model Series

Year

Sales Units

Sum of Sales Units

Column Labels

MY BRAND

Widget 1

MARKET

MARKET Total

MY BRAND

MY BRAND Total

Grand Total

MY BRAND

Widget 1

Row Labels

Widget 1

Widget 2

Widget 3

Widget 1

Widget 2

Widget 3

MY BRAND

Widget 1

MY BRAND

Widget 2

MY BRAND

Widget 2

MY BRAND

Widget 3

MARKET

Widget 1

MARKET

Widget 1

MARKET

Widget 1

MARKET

Widget 2

MARKET

Widget 3

<tbody>
[TD="align: center"]1
[/TD]

[TD="align: center"]2
[/TD]

[TD="align: right"]2015
[/TD]
[TD="align: right"]4407
[/TD]

[TD="align: center"]3
[/TD]

[TD="align: right"]2016
[/TD]
[TD="align: right"]714012
[/TD]

[TD="align: center"]4
[/TD]

[TD="align: right"]2017
[/TD]
[TD="align: right"]803727
[/TD]

[TD="align: left"]2015
[/TD]
[TD="align: right"]100.00%
[/TD]

[TD="align: right"]100.00%
[/TD]
[TD="align: right"]7.76%
[/TD]

[TD="align: right"]7.76%
[/TD]

[TD="align: center"]5
[/TD]

[TD="align: right"]2017
[/TD]
[TD="align: right"]1224
[/TD]

[TD="align: left"]2016
[/TD]
[TD="align: right"]100.00%
[/TD]

[TD="align: right"]100.00%
[/TD]
[TD="align: right"]71.14%
[/TD]

[TD="align: right"]78.35%
[/TD]

[TD="align: center"]6
[/TD]

[TD="align: right"]2016
[/TD]
[TD="align: right"]72398
[/TD]

[TD="align: left"]2017
[/TD]
[TD="align: right"]100.00%
[/TD]
[TD="align: right"]100.00%
[/TD]
[TD="align: right"]100.00%
[/TD]
[TD="align: right"]100.00%
[/TD]
[TD="align: right"]85.48%
[/TD]
[TD="align: right"]16.20%
[/TD]
[TD="align: right"]34.35%
[/TD]
[TD="align: right"]84.85%
[/TD]

[TD="align: center"]7
[/TD]

[TD="align: right"]2017
[/TD]
[TD="align: right"]552
[/TD]

[TD="align: left"]Grand Total
[/TD]
[TD="align: right"]100.00%
[/TD]
[TD="align: right"]100.00%
[/TD]
[TD="align: right"]100.00%
[/TD]
[TD="align: right"]100.00%
[/TD]
[TD="align: right"]76.08%
[/TD]
[TD="align: right"]974.35%
[/TD]
[TD="align: right"]34.35%
[/TD]
[TD="align: right"]79.43%
[/TD]

[TD="align: center"]8
[/TD]

[TD="align: right"]2015
[/TD]
[TD="align: right"]56766
[/TD]

[TD="align: center"]9
[/TD]

[TD="align: right"]2016
[/TD]
[TD="align: right"]1003657
[/TD]

[TD="align: center"]10
[/TD]

[TD="align: right"]2017
[/TD]
[TD="align: right"]940217
[/TD]

[TD="align: center"]11
[/TD]

[TD="align: right"]2017
[/TD]
[TD="align: right"]7556
[/TD]

[TD="align: center"]12
[/TD]

[TD="align: right"]2017
[/TD]
[TD="align: right"]1607
[/TD]

</tbody>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

Working demo file here
https://app.box.com/s/sius0bjszg5roozck86jaiafdp69vohs