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

Search results

  1. D

    Sparkline Chart

    Thank you so much for your help.
  2. D

    Sparkline Chart

    Hi, I tried Sparkline for showing Actual Vs. Target in one single chart. But its showing up in two different cells. Is there any way that we can show both Actual Vs. Target in one cell using Sparkline? I have attached the sample data for your consideration. Kindly support. This chart will be...
  3. D

    Circular Reference

    Thanks Chihiro. I doubted one formula and fixed it. After that everything seems to work fine. The reason why Excel was unable to point a cell, should be there were 2 references which were referring to each other. May be that's the reason why Excel was not able to point out one single cell as an...
  4. D

    Circular Reference

    I have already tried all of these. Even I have gone to each and every sheet and looked at Error Checking for any Cell reference. But nothing can be found. This kind of error is beyond the menu commands and I am not sure how to resolve it.
  5. D

    Circular Reference

    Hi, I came across a new issue in Circular Reference which doesn't say the cell reference in which there is a problem. Please help me with the attached error message. I have many excels and very few cells without a formula. In this scenario, its very difficult for me to find without any idea of...
  6. D

    Sum Product & Data Filter

    Thank you Khalid. Its a new learning for me. Any similar shortcut for Data Filter as well?
  7. D

    Sum Product & Data Filter

    Thank you Khalid. I have a different issue and I hope the attachment will make it clear. Please help.
  8. D

    Sum Product & Data Filter

    Similar to CountIF & SumIF, how good it will be if we have SumProductIF!!!! Likewise, in data filter it would be of great help if we have an inverse selection option. For ex: if we have selected 3 out of 10 values in the filter and now we need to select the rest 7 values, its manual and time...
  9. D

    Data --> Links Error

    Thanks. Got it.
  10. D

    Data --> Links Error

    Hi, I have a file with 10 sheets with formulas connecting to different files. Of which, I believe the linkage is lost in 2 of the files, as they are not saved. Can anyone please guide me on how to identify the sheet and the particular cell which has some reference to the 2 unsaved files? The...
  11. D

    Data Filter

    Very true. I often feel handicapped without this feature while filtering values. I believe it will be a blessing for all of us if Microsoft considers your suggestion.
  12. D

    Data Filter

    Its really amazing Jeff and works perfectly well for my requirements.
  13. D

    Find "~" Issue

    Thanks Deepak for your guidance. I learnt a new stuff today.
  14. D

    Find "~" Issue

    I came across a weird issue when I tried to find a cell value "80% ~ 100%". The problem is not with 80% or 100%. The issue here is the cell value has got the symbol "~" which Excel is unable to recognize. When you change the symbol from "~" to "-", excel promptly finds the value. This is so...
  15. D

    Data Filter

    Is there any way we can inverse the selected vales in a data filter? Assume, we have 5 values in Column A and already filtered Values 2 & 4. I am looking for a solution whereby I should be able to select rest of the values like 1, 3 & 5 by click of a button. Can anyone help with a macro or any...
  16. D

    Show Custom Icons according to Values

    One more clarification please.... When I check the Conditional Formatting by keeping the cursor for example in Cell C11 or C16, the Formula there still refers to $D10 only. But there is nothing wrong with the result. Any reason why it shows only the first value in the Range even when the...
  17. D

    Show Custom Icons according to Values

    You are really a Ninja. You deserve the title. It took me 5 minutes to understand what you did. Today I have learned somthing really awesome. This is a new dimension of how to use Conditional Fomatting and Wingdings Font together. May be Chandoo can publish an article on Conditional...
  18. D

    Show Custom Icons according to Values

    Guys, I need your expert help to show the relevant custom icons in Column C according to the values in Column B. I have attached the file for moe clarity. Your kind help is much appreciated. Regards, Ramnath
  19. D

    Excel Calculating Problem

    Many thanks Hui & Khalid for your expert advise. The calculating duration is now reduced to 45 seconds. For the benefit of everyone, may be you can consider posting these tips about the probable time consuming formulas, which can be avoided.
  20. D

    Excel Calculating Problem

    Yes. I have a 48 MB file which has the customer portfolio details and runs up to 77000 rows with 43 columns and additional 20 formula columns and 11 sheets. When ever I open this file, for every action, excel starts calculating and it really takes a decent 3 mins for every input. I need to...
  21. D

    Excel Calculating Problem

    Everyone must have come across this Calculating issue when excel is filled-up with formula. But I am wondering is there a way to find out which spcific cells are causing this issue? This is because, not all the formula cells are problematic. There might be very few cells containing volatile...
  22. D

    Chart Data Labels

    Thank you so much.
  23. D

    Chart Data Labels

    I am very curious to know how you have removed the dummy series legend. Can you please enlighten me?
  24. D

    Chart Data Labels

    Thanks a ton. This will save my time to a great extent. I have never used a dummy series like what you have done. Its a learning for me. Though we cannot remove the dummy series both from the table and in the legend, your tip is very handy and to the purpose. Please mark my query as "Solved".
  25. D

    Chart Data Labels

    Hi Somendra, Thanks for your quick reply. You are almost correct. But the issue here is, when we are in Sep, I need Sep values for all the 3 lines like Actual, Budget & Forecast. Eventhough, the Budget & Forecast start and end values are the same, the current month values need to be changed...
Back
Top