Forum Discussion

Copper Contributor

Nov 10, 2021

Breaking a line graph based on subcategory

I have created a pivot combo chart consisting of column/line graphs from a pivot table. The pivot table has subcategories as seen in the graph below e.g. Team 1, Team 2, Team 3 etc.. I'm tryi...

Charting

excel

Qaiser_j

Brass Contributor

Nov 12, 2021

Hi excelaaaa

I attached a sample chart. Data refresh in chart automatically as you change your data selection.

You can check this advance chart here for https://chartexpo.com/utmAction/NCtNVEMreGwrUUorTVNPRlRDTVQr.

And if you are comfortable with Google Sheets, you can find https://chartexpo.com/utmAction/NCtNVEMrZ3MrUUorTVNPRlRDTVQr.

Thanks