Excel charts deal with data issues

Well I was working on an assignment and got stuck in making charts. I found problem in my data table which contains duplicate values. so my data is not in proper format that's why charts are not showing results as required.

As you can see because of duplication of color value in this scenario i got messy chart... so that's where i stuck and have to looking up solutions to deal with this problem.

Solution:
First of all I have to arrange our data according to the proper format. lets find out all the brand colors and take data related required information. For this purpose I used different functions of excel in order to get the required results. First of all we have to find out unique values and then total value for each color for this purpose we use index match array formula.
For calculating unique values we use index match array formula as descried below..lemme explain this.
=INDEX(Table14[Farbe],MATCH(0,COUNTIF($L$5:L5,Table14[Farbe]),0))

this formula is combination of three formulas index, match and countif ... okay through countif function we count how many times color is duplicated, it starts from the first value and continue until the last value appears. Then we match the resultant value with zero (0) if current value is zero then match function return row number. After that we check this row number in range of table which is mentioned in index function.
When we finish with formula press Ctrl+Shift+Enter to apply formula on range. if no more unique value found this formula returns #NA which means we done here.
Yup we got solution that eliminate all duplicate values and just provide us unique values.. Now we match each color name in the given table and got all its value for making a chart...
Alright now we on to make values tables related to the color name....and may be just arrange data so all values belong to specific color should shown down its name. for this purpose use multiple functions. We start with matching values cell by cell if color name match with the cell value return its address and then from that specific row got the value of cell by defining the column number in the address function. Lemme explain this in detail how we gonna do that.
=INDIRECT(ADDRESS(IF(D5=$H$4,ROW()),5))
if function match value of row with color name, if value match it returns ROW# by using Row function.
Address function return the cell address by getting row number by using the Row function and column number which we specified..
Indirect function got the cell value from the give cell address.
..Cool now we arranged our data.
it's time to make charts :)

#value error shows that no value found on that row regarding the color. if you don't want to see this error simply use if error function in this regard. Like as below
=IFERROR(INDIRECT(ADDRESS(IF(D5=$H$4,ROW()),5)),"")
So your sheet would be look like as below.

Comparison of results are as shown below...before arranging the data and after arranging the data...

Closing:
This is how i deal with query which causing me trouble,,,if you face such situations kindly share your experience ....open for new experiences and ideas. Have fun. :)