$$Excel-Macros$$ Pie chart

2013-09-19 Thread joseph camill
Hi, I have a two slice pie chart and the first slice should face to the right centre horizontally. Can you provide a macro for this. Thanks for your help in advance. Regards, Joseph -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join

Re: $$Excel-Macros$$ Pie Chart Help

2013-07-03 Thread Rajan sharma
Thanks Vijay for sharing different charts. it will help a lot. With warm regards, Rajan Sharma On Wed, Jul 3, 2013 at 10:51 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Respected Waseem, please have a look at these charts. Regards, Vijaykumar On Wed, Jul 3, 2013 at 3:45 PM,

Re: $$Excel-Macros$$ Pie Chart Help

2013-07-02 Thread priti verma
PFA On Mon, Jul 1, 2013 at 3:12 AM, Rajan sharma rajansharma9...@gmail.comwrote: Dear Priti Mam, Thanks for the solution provided. Now i am trying to plot the same graph for different data, i don't understand why it is not working. please check and let me know. As of now, i have

Re: $$Excel-Macros$$ Pie Chart Help

2013-07-02 Thread Rajan sharma
Thanks Priti Mam, Brilliant chart. With warm regards, Rajan Sharma On Tue, Jul 2, 2013 at 1:05 PM, priti verma pritiverma1...@gmail.comwrote: PFA On Mon, Jul 1, 2013 at 3:12 AM, Rajan sharma rajansharma9...@gmail.comwrote: Dear Priti Mam, Thanks for the solution provided. Now

Re: $$Excel-Macros$$ Pie Chart Help

2013-07-01 Thread Rajan sharma
Dear Priti Mam, Thanks for the solution provided. Now i am trying to plot the same graph for different data, i don't understand why it is not working. please check and let me know. As of now, i have inserted some pie-shapes above the Doughnut graph in attachment. please find the attachment

Re: $$Excel-Macros$$ Pie Chart Help

2013-07-01 Thread Rajan sharma
Hi All, I got idea and have plotted, please find the attachment. See if it is ok. if needed please suggest with different charts. Warm regards, Rajan Sharma On Mon, Jul 1, 2013 at 2:42 PM, Rajan sharma rajansharma9...@gmail.comwrote: Dear Priti Mam, Thanks for the solution provided.

Re: $$Excel-Macros$$ Pie Chart Help

2013-07-01 Thread P.VIJAYKUMAR
Respected Priti Madam, I have also pasted the doughnut chart on the pie chart as mentioned by you in the process.After that when I Change the inner doughnut into a pie chart the whole chart is becoming a pie chart and it does not remain a combination chart.I do not understand the reason for

Re: $$Excel-Macros$$ Pie Chart Help

2013-06-27 Thread priti verma
Hi vijay, Pfa for more clarification On Wed, Jun 26, 2013 at 1:57 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Respected priti, I tried to paste the donought chart on the pie chart,but only a single chart is showing not both charts,how should we make both charts show at a time like the

Re: $$Excel-Macros$$ Pie Chart Help

2013-06-26 Thread P.VIJAYKUMAR
Respected Ranjan, When you select the data for the chart select the complete table along with C also.You have selected in the data upto B only and plotted the Pie Chart.Select C data also and plot the Chart and you will get the chart as per your requirement. Regards, VIJAYKUMAR On Wed, Jun

Re: $$Excel-Macros$$ Pie Chart Help

2013-06-26 Thread Rajan sharma
Yes sir, your points are valid, but you know, My requirement is not that. let me explain you, please see the below image. There you will find A and B is the Main type, C (light orange color) is only a subset of B, So, A= 927688 B= 1093947 Now C = 20 should be under B Area, it means out of

Re: $$Excel-Macros$$ Pie Chart Help

2013-06-26 Thread priti verma
Pfa Are you looking for this On Wed, Jun 26, 2013 at 11:56 AM, Rajan sharma rajansharma9...@gmail.comwrote: Yes sir, your points are valid, but you know, My requirement is not that. let me explain you, please see the below image. There you will find A and B is the Main type, C (light orange

Re: $$Excel-Macros$$ Pie Chart Help

2013-06-26 Thread P.VIJAYKUMAR
Respected Ranjan, For that type of data you can use a stacked pie chart or a pie of pie chart .You can find how to prepare a stacked pie chart in Ms Excel Help or you can follow the following links also.hope they may be of some help to you

Re: $$Excel-Macros$$ Pie Chart Help

2013-06-26 Thread Rajan sharma
Thanks Priti and Vijay and to all, yes it will help me to figure out my solution. thanks a ton champs. With warm regards, Rajan Sharma On Wed, Jun 26, 2013 at 12:30 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Respected Ranjan, For that type of data you can use a stacked pie chart or a pie

Re: $$Excel-Macros$$ Pie Chart Help

2013-06-26 Thread P.VIJAYKUMAR
Respected Priti, Can you explain the process of fusing the Pie and Doughnut Chart.How to edit the series as to show both the charts as single chart as shown in your attachment.Can you explain the process of making the chart or can you give a link to it. Thanks in advance, Regards, VIJAYKUMAR

Re: $$Excel-Macros$$ Pie Chart Help

2013-06-26 Thread priti verma
HI vijay use following steps 1).prepare two chart one is pie chart based on intermediate data and second is doughnut chart based on original data. 2).paste doughtnut chart on pie chart 3) and then arrange data labels of corresponding chart On Wed, Jun 26, 2013 at 12:53 PM, P.VIJAYKUMAR

Re: $$Excel-Macros$$ Pie Chart Help

2013-06-26 Thread P.VIJAYKUMAR
Respected priti, I tried to paste the donought chart on the pie chart,but only a single chart is showing not both charts,how should we make both charts show at a time like the one you did in the attachment. Regards, VIJAYKUMAR -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

$$Excel-Macros$$ Pie Chart category Fixed at One place

2013-02-20 Thread amar takale
Dear All Experts I Attached sheet in detail information,Only say It is possible? Regards Amar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1)

Re: $$Excel-Macros$$ pie chart -how to remove in chart

2011-09-08 Thread deepu
Well... The file is working fine in... you just need to save the workbook before you open it.. So select 'Save' option instead of 'Open' (to directly open the workbook), I've used dynamic ranges for charts, that might be the reason for why its not working... Best of Luck... :-) Regards Deepak

Re: $$Excel-Macros$$ pie chart -how to remove in chart

2011-09-06 Thread sandhya jain
This is actually not working i am not able to use it. pls help me On Sun, Sep 4, 2011 at 9:46 PM, ashish koul koul.ash...@gmail.com wrote: check the link http://www.andypope.info/charts/piezeros.htm On Sun, Sep 4, 2011 at 8:58 PM, sandhya jain sanya...@gmail.com wrote: Hi All, please

Re: $$Excel-Macros$$ pie chart -how to remove in chart

2011-09-06 Thread ashish koul
try the attached file On Tue, Sep 6, 2011 at 4:26 PM, sandhya jain sanya...@gmail.com wrote: sometime its a requirement to use pie. On Sun, Sep 4, 2011 at 10:54 PM, Deepak Pal Singh deepaktheind...@gmail.com wrote: Its better to not to use pie chart when you have many data points...

$$Excel-Macros$$ pie chart -how to remove in chart

2011-09-04 Thread sandhya jain
Hi All, please help me to remove 0 or null value in pie chart. file enclosed -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2.

Re: $$Excel-Macros$$ pie chart -how to remove in chart

2011-09-04 Thread ashish koul
check the link http://www.andypope.info/charts/piezeros.htm On Sun, Sep 4, 2011 at 8:58 PM, sandhya jain sanya...@gmail.com wrote: Hi All, please help me to remove 0 or null value in pie chart. file enclosed --

Re: $$Excel-Macros$$ pie chart -how to remove in chart

2011-09-04 Thread Deepak Pal Singh
Its better to not to use pie chart when you have many data points... FYI... On Sun, Sep 4, 2011 at 8:58 PM, sandhya jain sanya...@gmail.com wrote: Hi All, please help me to remove 0 or null value in pie chart. file enclosed --