I'm using numbers and I created a table that shows the percentage between expense and income. For instance under expense I have 1,127.90 which should correspond to 21.41% out of 5,268.59. When I create a 2d pie chart importing the data (data references): 1,121.90 out of 5.268.59, the chart reads 17.63% out of 5,268.59. What is going on? What is the graph interpreting?
It is a misunderstanding about pie charts.
In your table,
1127.9/5268.59 = 21.41%
In a pie chart with the values 1127.9 and 5268.59, each value is a slice of the pie.
The total of the values is the full pie = 1127.9+5268.59
The first slice is 1127.9/(1127.9+5268.59) =17.63%
The second slice is 5268.59/(1127.9+5268.59)=82.37%
The total of all slices is 100%
It is a misunderstanding about pie charts.
In your table,
1127.9/5268.59 = 21.41%
In a pie chart with the values 1127.9 and 5268.59, each value is a slice of the pie.
The total of the values is the full pie = 1127.9+5268.59
The first slice is 1127.9/(1127.9+5268.59) =17.63%
The second slice is 5268.59/(1127.9+5268.59)=82.37%
The total of all slices is 100%
thank you so much! I see it now!! I knew the problem was between the screen and the seat LOL!
Error between table data with graph
