Siddharth Rout
Active Member
- Joined
- Jan 7, 2022
- Messages
- 395
- Office Version
- 365
- Platform
- Windows
- MacOS
After a long time, someone asked me a question for which I did not have the right answer. I also tried finding the MS KB but couldn't find an EXACT reason.
Question: Why can't we create some pivot charts? Why does it show a message as shown below?
I know that it is a limitation with Excel. But WHY? What is stopping the chart from being created? The moment, I copy the exact table and paste them as values in a different area, then I can create a chart.
Any reasoning backed up with MS KB would be awesome.
Question: Why can't we create some pivot charts? Why does it show a message as shown below?
I know that it is a limitation with Excel. But WHY? What is stopping the chart from being created? The moment, I copy the exact table and paste them as values in a different area, then I can create a chart.
Any reasoning backed up with MS KB would be awesome.