Hi there,
i have two sheets in which one of the sheet contains raw data branch & model wise (the sheet name is "data is like this" in attached file).
in raw data, branch is in column and model is in row.
i need a formula to arrange this data in which branch & models both are in column.
pls...
Dear Sir,
in the attached file,
i want to show EMP count as column series while in same chart, i want to show primary & secondary as row series, but is not possible with a single legend.
so i want separate legends for column & row series.
pls help.
thanks.
hi there,
i want to use more than one (two) legends in my single chart.
how can I do so ??
sample data is below:
Region EMP Count Investment Cost
East 14 2.5%
West 10...
Hi There,
I am in search of a chart template which show attractively region vs branches break up.
My region is central, regional Productivity is 2.5%.
I have 5 branches is central region and productivity is as below-
Branch A - 2.5%
Branch B - 3.1%
Branch C - 1.9%
Branch D - 0.8%
Branch E -...
@Narayan
dear Sir,
I cant understand how to apply countif in subtotal ?
like =subtotal(2,?,?,?,...)
which function no. should i use and how apply the condition??
dear all,
I have a table, in which a column named Grade contains A, B, C, .... F.
now I insert a pivot table, in value field, when i drag the grade field, naturally it displays count of grade. pls note that in colum field i put exam and every exam has unique grades e.g. exam 1 has A to F grade...
hi all,
I have some values between 1 and 12 in col A. these are month numbers.
now i want a format which will convert each month by its name, like 1 show Jan, 2 - Feb and so on.
I use custom formatting as MMM but all values shows JAN only.
how can it possible?
Dear All,
I have an Excel sheet, I want to link this sheet to PowerPoint, when I update the data in excel sheet, the chart automatically update in PPT, how can I link this excel sheet with PPT.
@NARAYANK991
Dear Sir,
this formula is perfect, but here is a little problem, I specify the conditions again:-
if Aging is 1 Year then all products are In Warranty, If Aging is 2 Year - 3 Year then MNT and those REF which are nimbus are in warranty and all other Out of Warranty and if aging is...
A B C D
Aging PDT Nimbus Wty Status
1 Year Audio N
2 Year REF N
1 Year MNT N
2 Year REF Y
1 Year RAC N
3 Year LTV N
4 Year PTV N
5 Year WM N
I want the result in D colum, conditions are as below:-
For aging 1 Year - All Products In Wty
For aging 2 Year-3 Year - MNT and REF...
Hi all,
I have a database, screen shot is below-
A B C D
1 Aging PDT Nimbus Wty Status
2 1 Year Audio N
3 2 Year REF N
4 1 Year MNT N
5 2 Year REF Y
6 1 Year RAC N
7 3 Year LTV N
8 4 Year PTV N
9 5 Year WM N
I want the result in D colum, conditions are as below:-
For aging...