Excel 2016 Bar chart with Total and Count

[milindsaraswala]

I have excel sheet with category and Price. Category are repeating
1.PNG
enter image description here

As category was repeating. I could not make proper chart. So make temporary table with removing duplicate data from category and another column with sumif formula and output as below enter image description here
2.PNG

and created chart from as below enter image description here
3.PNG

Now My question is can we add count of category as well with Total on chart but not separate bars. Please show me the path

[Kaper]

As you use excel 2016 you can freely modify bar labels. For instance using "values from range".
So if your SUMIF is in column F write COUNTIF in column G and in column H formula:

Please Login or Register  to view this content.

and copy down.
Use this column as ranve with label values.
See attached

[milindsaraswala]

Thank you very much, it was really helpful