Can't able to create chart from Pivot table in excel 2016 for mac.

Copper Contributor

Can't able to create the chart from the pivot table. I am using the excel 2016 for mac. Can anybody help to understand what am I doing wrong? After clicking ok nothing is happening, I am getting the same blank slate. In this example, I am trying to create the chart only for Alberta for the year 2010. I can't use the automatic chart feature, I have to do it manually. Any help regarding doing manually will be very helpful.charts_basics.png

1 Reply

What happens when you select some data, not just the labels for the X axis? Excel needs numbers to create a chart. You have not selected any numbers.