Ok,
I am sure there is a simple answer to this (even if that answer is "it cant be done"), i jsut cant figure it out. I have an excel sheet with how much total money is owed and how much we have currently recieved. i.e. $48,000 recieved and $50,000 total owed. I know the disparancy is $2,000. I want to be able to make a pie chart that would show that out of $50,000 we have recieved $48,000 and are still owed the $2,000. I know a simple way would be to create an additional cell that subtracts the two cells from each other and then just include that cell in the graph, but we dont want to do this.
So, is there any way to enter a formula into the "data range" blank when i try to make the pie chart so it will do the division for us? If not, please just post letting me know that so i can stop wondering.
Thanks in advance!
You could define a NAME
Assume A1, B1 = Owed, Received
A2, B2 = 50000, 48000
You want to keep it like this and not make a "helper" column (C1,C2), right?
Then
Do this:
Define Name
MyData: =Sheet1!$A$2:$B$2-Sheet1!$B$2:$C$2
MyLabel: ={"Difference","Received"}
Save the WB as PieChart.xls
Change the Series into: SERIES(,PieChart.xls!MyLabel,PieChart.xls!MyData,1)
Last edited by rwgrietveld; 03-04-2010 at 03:57 PM.
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks