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

$$Excel-Macros$$ Intersection of points in graph

2013-06-26 Thread Krishnaraddi V. Madolli
CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient

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

Re: $$Excel-Macros$$ Re: Excel Macro to import specific data from PDF to Excel

2013-06-26 Thread De Premor
Here is the sample, i'am using xpdf, a free software to convert your pdf to text, then read that text to get the desired value You can download xpdf from www.foolabs.com/xpdf/download.html and put file named pdftotext.exe in same folder with this attachment. Rgds, [dp] On 26/06/2013 11:45,

$$Excel-Macros$$ Collate data from folder

2013-06-26 Thread Rajan sharma
Dear All, I have more than 100 excel files in a single folder. And all the folder has common headings. I want to collate all the 100 excel files into as one single sheets. How to do that, Is there option in excel upload option or by Vba ?. Plse suggest. My files are in D drive and folder

$$Excel-Macros$$ Screenshot with different shapes

2013-06-26 Thread Pravin Gunjal
*May I know how to take a screenshot with the shape given below. Thanks.* [image: Inline image 1] -- 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

Re: $$Excel-Macros$$ Collate data from folder

2013-06-26 Thread Sam Mathai Chacko
http://www.excelfox.com/forum/f2/copy-data-from-multiple-workbooks-to-a-master-workbook-1045/ http://www.excelfox.com/forum/f2/consolidate-multiple-workbooks-from-a-folder-into-one-master-file-vba-1077/ Try these Regards, Sam On Wed, Jun 26, 2013 at 6:16 PM, Rajan sharma

Re: $$Excel-Macros$$ Intersection of points in graph

2013-06-26 Thread ashish koul
. check the attachment see if it helps On Wed, Jun 26, 2013 at 12:42 PM, Krishnaraddi V. Madolli krishnaraddi.mado...@asia.xchanging.com wrote: CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this

Re: $$Excel-Macros$$ Intersection of points in graph

2013-06-26 Thread Santy
Hi Sir, superb !! can u please share steps ..how to create *Thanks Regards,* *Santy* On Wed, Jun 26, 2013 at 8:47 PM, ashish koul koul.ash...@gmail.com wrote: . check the attachment see if it helps On Wed, Jun 26, 2013 at 12:42 PM, Krishnaraddi V. Madolli

Re: $$Excel-Macros$$ Re: Excel Macro to import specific data from PDF to Excel

2013-06-26 Thread harh2
Hi, thanks for the file but I got run time error 53. File not found? On Tuesday, June 25, 2013 11:45:20 PM UTC-5, Francis Mukobi wrote: Basole ricar...@gmail.com javascript: wrote: Hamood, post your PDF file and tell what data you want to import Em terça-feira, 25 de junho de 2013

Re: $$Excel-Macros$$ Re: Excel Macro to import specific data from PDF to Excel

2013-06-26 Thread De Premor
Ups sorry, my mistake Try new attached file Rgds, dp On 27/06/2013 1:13, ha...@mst.edu wrote: Hi, thanks for the file but I got run time error 53. File not found? On Tuesday, June 25, 2013 11:45:20 PM UTC-5, Francis Mukobi wrote: Basole ricar...@gmail.com javascript: wrote: Hamood,

RE: $$Excel-Macros$$ Intersection of points in graph

2013-06-26 Thread Krishnaraddi V. Madolli
Thanks a lot Ashish. Regards, Krishnaraddi V Madolli. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: 26 June 2013 20:48 To: excel-macros Subject: Re: $$Excel-Macros$$ Intersection of points in graph . check the attachment see if it

Re: $$Excel-Macros$$ Collate data from folder

2013-06-26 Thread Rajan sharma
Dear Sam, Sorry for the late reply. Thanks sir for sharing me the link, really that was awesome and help me solve my query. thanks With warm regards, Rajan Sharma On Wed, Jun 26, 2013 at 7:35 PM, Sam Mathai Chacko samde...@gmail.comwrote:

$$Excel-Macros$$ Plz help me to solve this prob

2013-06-26 Thread thameem
Dear all, Am getting below message, when ever I delete row or column, and my system is getting hanged, am unable to do any editing. plz help me out. the operation you are about to perform affects a large number of cells and may take a significant amount of time to complete. are you sure you

RE: $$Excel-Macros$$ Plz help me to solve this prob

2013-06-26 Thread Amit Desai (MERU)
In this case, you should do as follows; In case if you wants to delete all the contents of raw, select all the cells of that raw from first to last till the column heads are there, right click with mouse, select on Delete, on asking where to shift the below cells select shift cells up. You

Re: $$Excel-Macros$$ Plz help me to solve this prob

2013-06-26 Thread thameem
Thank you, i will follow your step, but is any other solution for this? plz tell me, y this prob occurs, so i can take precautions in any other files. On Thu, Jun 27, 2013 at 9:14 AM, Amit Desai (MERU) amit.de...@merucabs.comwrote: In this case, you should do as follows; ** ** In

$$Excel-Macros$$ Re: Introduce Yourself !!

2013-06-26 Thread sandeep shivpujan singh
Hi Everyone, I am Sandeep S Singh from India Hyderabad. I am a Software Engineer working with Cognizant. I have just now joined this group It is my first post. I work on QTP and Excel Macros. looking forward to interact with everyone here. have a good day :-) Thank, Sandeep Singh On

RE: $$Excel-Macros$$ Plz help me to solve this prob

2013-06-26 Thread Amit Desai (MERU)
When you select entire raw/column... it selects all the cells of that raw/column (even unused) of your sheet...so in case if the file is huge this will definitely take long time to process by excel. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of thameem

Re: $$Excel-Macros$$ Plz help me to solve this prob

2013-06-26 Thread thameem
Is any possibility to delete unused cells in row and column, so i can reduce load, present am using 3000 rows and 40 columns rest all rows and coloumns are empty, thank you for ur support. On Thu, Jun 27, 2013 at 9:33 AM, Amit Desai (MERU) amit.de...@merucabs.comwrote: When you select entire

RE: $$Excel-Macros$$ Plz help me to solve this prob

2013-06-26 Thread Amit Desai (MERU)
Yes, you can select those raws by shift +control + Down Arrow Delete. Similarly columns can be removed by shift + Control + Right Arrow Delete. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of thameem Sent: 27 June 2013 11:07 To:

Re: $$Excel-Macros$$ Plz help me to solve this prob

2013-06-26 Thread thameem
getting error as excel cannot complete this task with available resources. choose less data or close other applications On Thu, Jun 27, 2013 at 9:42 AM, Amit Desai (MERU) amit.de...@merucabs.comwrote: Yes, you can select those raws by shift +control + Down Arrow Delete.** ** Similarly

RE: $$Excel-Macros$$ Plz help me to solve this prob

2013-06-26 Thread Amit Desai (MERU)
It might be due to low RAM. If you are using MS Excel 2007, change the file type to Excel Binary Workbook. This file type will compress the data in lowest possible size. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of thameem Sent: 27 June 2013 11:15 To: