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
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
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
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
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
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
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
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
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
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,
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
*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
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
. 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
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
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
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,
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
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:
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
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
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
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
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
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
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:
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
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:
28 matches
Mail list logo