Hi all, Is there a way to draw 3D pie with R (like excel does)? I know how to do it in 2D, just by using pie(something)... I know it isn't the best way to represent data, but people are sometimes more interested by the look and feel than by the accuracy of the results... If there is no way, have you another suggestion ? (i already use dotchart instead of pie) Thks to all of you. COMTE Guillaume [[alternative HTML version deleted]]
You can see my opinion of 3D piecharts at http://www.burns-stat.com/pages/Tutor/spreadsheet_addiction.html Patrick Burns patrick at burns-stat.com +44 (0)20 8525 0696 http://www.burns-stat.com (home of S Poetry and "A Guide for the Unwilling S User") COMTE Guillaume wrote:>Hi all, > > > >Is there a way to draw 3D pie with R (like excel does)? > > > >I know how to do it in 2D, just by using pie(something)... > > > >I know it isn't the best way to represent data, but people are sometimes >more interested by the look and feel than by the accuracy of the >results... > > > >If there is no way, have you another suggestion ? (i already use >dotchart instead of pie) > > > >Thks to all of you. > >COMTE Guillaume > > > [[alternative HTML version deleted]] > >______________________________________________ >R-help at stat.math.ethz.ch mailing list >https://stat.ethz.ch/mailman/listinfo/r-help >PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html > > > >
Since everyone else wimped out with a tedious you-do-not-want-to-do-that,
here is a solution that uses R to control Excel and create a 3d chart.
You will
need the RDCOMclient package that you can find via google.
library(RDCOMClient)
xl <- COMCreate("Excel.Application") # starts up Excel
xl[["Visible"]] <- TRUE # Excel becomes
visible
wkbk <- xl$Workbooks()$Add() # new workbook
# set some cells
sh <- xl$ActiveSheet()
for(i in 1:5) {
lab <- sh$Cells(i,1)
lab[["Value"]] <- letters[i]
val <- sh$Cells(i,2)
val[["Value"]] <- i
}
ch <- xl$Charts()
ch$Add()
ac <- xl$ActiveChart()
xl3DPieExploded <- 70
ac[["ChartType"]] <- xl3DPieExploded
xlColumn <- 2
ac$SetSourceData(Source = sh$Range("A1:B5"), PlotBy = xlColumn)
# now right click the chart and make any other settings you like.
On 4/18/06, COMTE Guillaume <g.comte at alliance-ir.net>
wrote:> Hi all,
>
>
>
> Is there a way to draw 3D pie with R (like excel does)?
>
>
>
> I know how to do it in 2D, just by using pie(something)...
>
>
>
> I know it isn't the best way to represent data, but people are
sometimes
> more interested by the look and feel than by the accuracy of the
> results...
>
>
>
> If there is no way, have you another suggestion ? (i already use
> dotchart instead of pie)
>
>
>
> Thks to all of you.
>
> COMTE Guillaume
>
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide!
http://www.R-project.org/posting-guide.html
>
Gabor Grothendieck wrote:> Since everyone else wimped out with a tedious you-do-not-want-to-do-that, > here is a solution that uses R to control Excel and create a 3d chart.. . . People really ***should not*** be encouraged or abetted in wrong-headedness. Excel is terrible. Pie charts are terrible. Don't mess with them. Period. cheers, Rolf Turner rolf at math.unb.ca
Hi all, I can understand that it isn't the right way to represent data, i knew that i would hurt some people on this mailling list to discuss about pie. As i've specified on my first message: My only purpose of drawing 3D pie is for customer who don't have to understand what is drawn , but only be impressed by the beauty of the result (like people at commercial division which purchase what you've done but don't use it). Then the expert (who are the ending users) will use the dotchart version (which i've putted too) instead of the pie. Note:it isn't my idea, i wish to follow these advices, but i'm not the buyer... That's all, and for shure i won't forget that pie isn't good, or only at dinner time. Bring me a 3D apple pie and a coffee it's the morning here! (or a sandwich with hamm) Thks for all the answers, Grothendieck, thanks for the R tips with excel,but i'm working under linux, will keep this example in a safe place, could be usefull one day, who knows... Cheers COMTE Guillaume -----Message d'origine----- De?: Frank E Harrell Jr [mailto:f.harrell at vanderbilt.edu] Envoy??: mercredi 19 avril 2006 21:14 ??: Rolf Turner Cc?: ggrothendieck at gmail.com; COMTE Guillaume; r-help at stat.math.ethz.ch Objet?: Re: [R] 3D pie Rolf Turner wrote:> Gabor Grothendieck wrote: > > >>Since everyone else wimped out with a tedious you-do-not-want-to-do-that, >>here is a solution that uses R to control Excel and create a 3d chart. > > . > . > . > > People really ***should not*** be encouraged or abetted in > wrong-headedness. Excel is terrible. Pie charts are terrible. > Don't mess with them. Period. > > > cheers, > > Rolf Turner > rolf at math.unb.caI second that. Helping people do things known to have major problems with the approaches can actually hurt others in the long run. 2-D pie charts are terrible. That makes 3-D pie charts terrible to the 3/2 power. Excel has serious errors and is not a good model for reproducible research. -- Frank E Harrell Jr Professor and Chair School of Medicine Department of Biostatistics Vanderbilt University
>>>>> "COMTE" == COMTE Guillaume <g.comte at alliance-ir.net> writes:> I know it isn't the best way to represent data, but people > are sometimes more interested by the look and feel than by > the accuracy of the results... If they aren't intersted in the results, why not just print some random 3D pie chart and use that? Why do you need to produce a new one at all?