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

    Automatic date update in a cell when another cell's value changes [SOLVED]

    thank you sirjb7 but can you suggest some books or reference material I can through to develop my skills and techniques on VBA coding.
  2. V

    Automatic date update in a cell when another cell's value changes [SOLVED]

    hi sirjb7, thank you sirjb7 for your explanation . I think it will take some time for me to understand . let me slowly try to understand it. but I would like to write code like you as well. but let's see how it goes...... :)
  3. V

    Automatic date update in a cell when another cell's value changes [SOLVED]

    hi sirjb7, if you could provide me the explanation then I can also learn how to write complex codes. :)
  4. V

    Automatic date update in a cell when another cell's value changes [SOLVED]

    Thank you so much both of us. Both the codes are working fine. But sirjb7 codes are little bit difficult to understand it. Anyway thank you so much for helping me.
  5. V

    Automatic date update in a cell when another cell's value changes [SOLVED]

    Hi SirJB7, http://www.mediafire.com/?dqbxs09xt7p5igh In my sample file attached in the below link, the range of cell need to be set is "C3:M6". Meaning when ever they are changing on this range based on the product, the current date and time need to entered in column B. For example if i...
  6. V

    Automatic date update in a cell when another cell's value changes [SOLVED]

    Hi All, I need an help one excel formula ,i have specific range with prices, but when ever there is a change in value in the range then one particular need to be updated with now() formula. Find below the snap shot of desired data.... Product Changes happened Jan'13 Feb'13 Mar'13 Apr'13...
  7. V

    Conditional formatting - Customized icon sets

    Thanks for your reply. But if include the character can i able to get it as fully colored one like we are getting it in CF. Another question can we able to create conditional formatting like one condition for color and one condition for the shape is it possible in excel 2007?
  8. V

    Conditional formatting - Customized icon sets

    Its for excel 2007 , but there is no icon set available in CF for right and left arrow symbol. Can you please help me how i can get that. Can i able icon like this "<->" in conditional formatting.
  9. V

    Conditional formatting - Customized icon sets

    Hi, Actually i am looking for an conditional formatting with icon set of "Left and Right arrow" with the colored one like amber. I know that i can get this using windings font but i dont know how to color those arrows. Can you please anyone help me on this. Thanks in advance.
  10. V

    Graph data labels need to give text based on the value selected

    Thanks Kaushik, Your example and explanation are pretty much clear but i need to think little bit to implement in my original. let me try it.
  11. V

    Graph data labels need to give text based on the value selected

    Hi Kaushik, If suppose i too have my comments based on my month then in that case how i can pick up the correct comment , hope you can understand by look at my sample file. http://rapidshare.com/files/3453926849/Sample%20Graph_2.xlsm
  12. V

    Graph data labels need to give text based on the value selected

    hi Kaushik, thanks once again for your time. that's all i wanted . i appreciate all your efforts. My final question why we need to move the graph into another sheet why can't we keep it in sheet 1 itself and try this code. any specific reason behind it...?
  13. V

    Graph data labels need to give text based on the value selected

    Hi Kaushik, Thanks for the reply but your code not showing the comment instead of it saving it in sheet2. I think i did not clearly tell my requirement . please have a look at in the sample file i have provided. In my sample my comments are in row no 14 in this case for picking the comment...
  14. V

    Graph data labels need to give text based on the value selected

    Thanks Kaushik its really helpful but now i am again with tricky question for me, instead of vlookup can we use Hlookup or offset formula , because suppose if i have like below; Students A B C D E F G marks 35 40 55 50 68 75 85 cooments poor - study well poor need to improve need to improve...
  15. V

    Graph data labels need to give text based on the value selected

    Hi All, Can you please help me on this code only. in the above mentioned the comments are based on the next column but shall i use vlookup function instead of getting at next column. TempStat = Worksheets("Sheet1").Range("C" & (Arg2 + 1)).Value This code need to be changed with vlookup...
  16. V

    Graph data labels need to give text based on the value selected

    Hi SirJB7, You guys deserved for these words its my pleasure to told this to you. I have some questions for trying to understand better; 1. Why we need to move the graph into separate sheet and include this code. Its not possible to work these codes in sheet1 itself?
  17. V

    Graph data labels need to give text based on the value selected

    Hi Guys, Hope you all busy in weekends i have got the answer for que.2 in my previous post. now i need to know only question 1 why we need to move the chart into separate sheet can we implement in sheet1 itself.
  18. V

    Graph data labels need to give text based on the value selected

    Hi SirJB7, You guys deserved for these words its my pleasure to told this to you. I have some questions for trying to understand better; 1. Why we need to move the graph into separate sheet and include this code. Its not possible to work these codes in sheet1 itself? 2. Can we implement...
  19. V

    Graph data labels need to give text based on the value selected

    Thank you so much kaushik ans sirjb7, its pleasure to meet you guys in this forum. Thanks a lot....
  20. V

    Graph data labels need to give text based on the value selected

    Hi Kaushik, Thanks for your time in detail explanation. i did everything but when i click the data label it showing the error of object required and it stops in this line of code "TempStat = Sheet1.Range("C" & (Arg2 + 1)).Value". link of the updated file...
  21. V

    Graph data labels need to give text based on the value selected

    hi kaushik, thanks for the response. kindly get the sample file in the link below; http://rapidshare.com/files/1152172019/Sample%20Graph.xlsx 1. text should be displayed inside text box with close option. 2.yes if the user click particular data label then relevant text need to displayed...
  22. V

    Graph data labels need to give text based on the value selected

    hi all, i have a chart in sheet1 and i have series of text and related chart data in sheet2. if any user select any data point in the chart, then based on the value selected the related text need to be displayed from sheet2. how i can do that in excel graphs.
Back
Top