• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by jsk_lge

  1. jsk_lge

    Formula required for sum!!

    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...
  2. jsk_lge

    Multiple Legends in single chart.

    Thank you very much Hui sir.
  3. jsk_lge

    Multiple Legends in single chart.

    yes !!! but how I can ??
  4. jsk_lge

    Multiple Legends in single chart.

    Dear HUI, sorry for delay, I want a chart something like in attached sheet. pls suggest how to make it ?
  5. jsk_lge

    Multiple Legends in single chart.

    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.
  6. jsk_lge

    Multiple Legends in single chart.

    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...
  7. jsk_lge

    Region vs Branches Breakup chart template

    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 -...
  8. jsk_lge

    Count non prime numbers only

    Thanks Narayan, your formula works.
  9. jsk_lge

    Count non prime numbers only

    I have many numbers in a colum. I want to count only those numbers which are divisible by 2. which formula should I use?
  10. jsk_lge

    Countif in a filtered list

    @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??
  11. jsk_lge

    Countif in a filtered list

    I have a filtered list contains letters a, b, c, d etc. i want to count those cells only which contains "d". which function should i use?
  12. jsk_lge

    Want Grade in value field instead of count in a pivot table

    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...
  13. jsk_lge

    Date Format Problem

    yeah its working thank you
  14. jsk_lge

    Date Format Problem

    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?
  15. jsk_lge

    Data table on top in Chart.

    I have a chart in which data table is shown at the bottom but i want to show it on top, how will it possible?
Back
Top