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

2013-06-26 Thread priti verma
Hi vijay, Pfa for more clarification On Wed, Jun 26, 2013 at 1:57 PM, P.VIJAYKUMAR 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 one you did in th

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

2013-06-26 Thread xlstime
Welcome Sandeep Looking forward to your active participation in group. Keep posting . Enjoy Team XLS On Thu, Jun 27, 2013 at 10:57 AM, sandeep shivpujan singh < mandy07s...@gmail.com> wrote: > Hi Everyone, > > I am Sandeep S Singh from India > Hyderabad. I am a Soft

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

2013-06-26 Thread VBA VABZ
Hi Either your table is corrupted, re-created new excel file using pasting values. Best Luck. On Thu, Jun 27, 2013 at 11:45 AM, thameem wrote: > Still getting hanged, even it was converted in to binary file, i tried to > delete empty rows, but not working > > > On Thu, Jun 27, 2013 at 9:55 AM

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

2013-06-26 Thread thameem
Still getting hanged, even it was converted in to binary file, i tried to delete empty rows, but not working On Thu, Jun 27, 2013 at 9:55 AM, Amit Desai (MERU) wrote: > 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

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

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) wrote: > Yes, you can select those raws by shift +control + Down Arrow & Delete.** > ** > > Similarly columns can be removed

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: excel-macros@googlegroup

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) wrote: > When you select entire raw/column... it select

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

$$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 Satur

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) wrote: > In this case, you should do as follows; > > ** ** > > In case if you wants to d

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 wi

$$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 want

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 wrote: > > http://www.excelfox.com/forum/f2/copy-data-from-multiple-workbooks-to

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 hel

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 > wrote: >Hamood, post your PDF file and tell wh

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 > wrote: > > >Hamood, post your PDF file and tell what data you want to import > > > > > > > >Em terça-feira, 25 de junho de 2013 13h36min05s UTC-3, ha..

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 wrote: > . check the attachment see if it helps > > > > On Wed, Jun 26, 2013 at 12:42 PM, Krishnaraddi V. Madolli < > krishnaraddi.mado...@asia.xchanging.com>

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

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 wrote: > Dear A

$$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

$$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

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,

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 wann

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 wrote:

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

$$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 pleas

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 wrote: > Respected Ranjan, > > For that type of data you can use a stacked pie chart or a pie of pie > chart .Y

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 http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp