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?