When you are creating Pie charts First Column that you are adding should be String column type and it will be used for pie slices names. Second column should be Integer or Float column type and it will be used for pie slices values.
There is some issue in Google Charts when you are using just numbers in the String (first) column. So the values should be something like in Selection_002.png image from the attachment. If you are using Highcharts or Chart.js you could just put numbers (In your case years) in the first column like in the Selection_003.png image from the attachment.
So from these pictures Year column will be used for slices names and Value column will be used for slices values.
I have a column of years, i.e. 2010, 2012, 2014, etc...
I want a pie chart that shows me the percentage of rows with each year.
i.e. 20% = 2010, 30% = 2012, 50% = 2014.
Here's where i'm confused,
When i go through the chart creation wizard, the pie chart requires two columns of data, but i just need a chart based on the years within one column.
Thanks for any assistance
Hi homemadebyx,
Thank you for the purchase.
When you are creating Pie charts First Column that you are adding should be String column type and it will be used for pie slices names. Second column should be Integer or Float column type and it will be used for pie slices values.
There is some issue in Google Charts when you are using just numbers in the String (first) column. So the values should be something like in Selection_002.png image from the attachment. If you are using Highcharts or Chart.js you could just put numbers (In your case years) in the first column like in the Selection_003.png image from the attachment.
So from these pictures Year column will be used for slices names and Value column will be used for slices values.
Hope this helps!