Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pie Charts
I am trying to use a pie chart. What I wont to do is this.
Cell M1 = How much money I made this month. Cell M4 = How much I wrote in checks. I wont the pie chart to show "M1" that is the pie it self = "M1" and I wont the pie slice (one slice) to show "M4" I cant seem to get the pie chart to equal "M1". "M1" allways shows up as a slice it self. Can it be done? Scott Burke |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pie Charts
In some cell, say M5, enter =M1-M4.
Plot M4:M5. The first slice will be M4. The 2nd slice will represent the savings for the month. The total pie, of course, will represent the money made in the month. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I am trying to use a pie chart. What I wont to do is this. Cell M1 = How much money I made this month. Cell M4 = How much I wrote in checks. I wont the pie chart to show "M1" that is the pie it self = "M1" and I wont the pie slice (one slice) to show "M4" I cant seem to get the pie chart to equal "M1". "M1" allways shows up as a slice it self. Can it be done? Scott Burke |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pie Charts
Hi Tushar. Thank you for your time. Maybe I did not explain what I was
after. Let me try again. 1) I wont the hole pie to equal "M1". example M1 = 500 I wont the hole pie to equal 500 2) I wont the slice of pie to equal "M4". example M4 = 100 I wont only ONE (1) slice in the pie. That slice should equal = 100 or 1/5 of the pie. how do I assign the whole pie a value???? Scott Burke "Tushar Mehta" wrote: In some cell, say M5, enter =M1-M4. Plot M4:M5. The first slice will be M4. The 2nd slice will represent the savings for the month. The total pie, of course, will represent the money made in the month. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I am trying to use a pie chart. What I wont to do is this. Cell M1 = How much money I made this month. Cell M4 = How much I wrote in checks. I wont the pie chart to show "M1" that is the pie it self = "M1" and I wont the pie slice (one slice) to show "M4" I cant seem to get the pie chart to equal "M1". "M1" allways shows up as a slice it self. Can it be done? Scott Burke |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pie Charts
Hi Scott,
As Tushar points out your pie chart must contain 2 values. For easy of chart creation use the following cell values. M1: =500 M4: =100 M5: =M1-M4 Select the range M4:M5 and use the chart wizard to create a 2 slice pie chart. Click the pie and then click the second slice. Press CRTL+1 to bring up the Format Data Point dialog. Set the Area and Border colours to None. This will leave you a slice 1/5th of the pie. Cheers Andy Scott Burke wrote: Hi Tushar. Thank you for your time. Maybe I did not explain what I was after. Let me try again. 1) I wont the hole pie to equal "M1". example M1 = 500 I wont the hole pie to equal 500 2) I wont the slice of pie to equal "M4". example M4 = 100 I wont only ONE (1) slice in the pie. That slice should equal = 100 or 1/5 of the pie. how do I assign the whole pie a value???? Scott Burke "Tushar Mehta" wrote: In some cell, say M5, enter =M1-M4. Plot M4:M5. The first slice will be M4. The 2nd slice will represent the savings for the month. The total pie, of course, will represent the money made in the month. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I am trying to use a pie chart. What I wont to do is this. Cell M1 = How much money I made this month. Cell M4 = How much I wrote in checks. I wont the pie chart to show "M1" that is the pie it self = "M1" and I wont the pie slice (one slice) to show "M4" I cant seem to get the pie chart to equal "M1". "M1" allways shows up as a slice it self. Can it be done? Scott Burke -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pie Charts
Thanks Tushar and Andy.
Andy, I will give this a try tonight. Scott "Andy Pope" wrote: Hi Scott, As Tushar points out your pie chart must contain 2 values. For easy of chart creation use the following cell values. M1: =500 M4: =100 M5: =M1-M4 Select the range M4:M5 and use the chart wizard to create a 2 slice pie chart. Click the pie and then click the second slice. Press CRTL+1 to bring up the Format Data Point dialog. Set the Area and Border colours to None. This will leave you a slice 1/5th of the pie. Cheers Andy Scott Burke wrote: Hi Tushar. Thank you for your time. Maybe I did not explain what I was after. Let me try again. 1) I wont the hole pie to equal "M1". example M1 = 500 I wont the hole pie to equal 500 2) I wont the slice of pie to equal "M4". example M4 = 100 I wont only ONE (1) slice in the pie. That slice should equal = 100 or 1/5 of the pie. how do I assign the whole pie a value???? Scott Burke "Tushar Mehta" wrote: In some cell, say M5, enter =M1-M4. Plot M4:M5. The first slice will be M4. The 2nd slice will represent the savings for the month. The total pie, of course, will represent the money made in the month. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I am trying to use a pie chart. What I wont to do is this. Cell M1 = How much money I made this month. Cell M4 = How much I wrote in checks. I wont the pie chart to show "M1" that is the pie it self = "M1" and I wont the pie slice (one slice) to show "M4" I cant seem to get the pie chart to equal "M1". "M1" allways shows up as a slice it self. Can it be done? Scott Burke -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
Pasting worksheet with embedded charts | Charts and Charting in Excel | |||
Charts won't update | Charts and Charting in Excel | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
linkingof charts in worksheets to cells | Excel Discussion (Misc queries) |