I'm Having Issues with my Excel in formatting charts and changing data of charts

Hello Tech Community, I'm new because Microsoft support team suggested me to come here and ask all the doubts and get them cleared.

I'm Using the Excel LTSC version, in that when I created a dashboard for practice purpose, I  wasn't able to change the data of a chart, and I'm not able to format charts(paste special isn't working),because of this I had to create same charts with colour code and size dimension and everything again and again manually which was a huge pain.

so I asked chatgpt and tried almost all methods except reinstallation, after nothing works, I've reinstalled also, still no use.

even my mentor also don't know what to do.

it doesn't have to do anything 'protected sheet/workbook'
because I've tried that also.

From the main data set in sheet 1 I created pivot tables in a separate sheet (sheet 2), from that I created charts in another separate sheet (sheet 3 - Dashboard), and when I tried to change the data of a chart - not working, when I try to copy the style I created in a chart to another similar type chart - not working(paste special isn't working).


so Excel specialists, Please Help me.