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

  1. W

    Help.. VBA code does not autorun

    Just figured it out I wrote first line as Private Sub Test () Now changed it to following and it worked. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Many thanks though for your support
  2. W

    Help.. VBA code does not autorun

    Thank you Logit a lot for your prompt response. Actually I am not a VBA person so would appreciate if you could elaborate a bit about what is "MyMacro". It didnt work for me somehow. Cheers
  3. W

    Help.. VBA code does not autorun

    Dear VBA Gurus Years ago I saw a post on this forum wherein if you click within a particular range of cells, the value in the selected cell is produced in a destination cell. For that I used following code: >>> use code - tags <<< Private Sub Macro1() If Not...
  4. W

    Bar charts change colors based on dates selection [SOLVED]

    Thank you so very much Narayank991.. That's exactly what i was looking for. Salute to all of you (dan_I, Hui and Narayan :)
  5. W

    Bar charts change colors based on dates selection [SOLVED]

    Thank you very much dan_I and Hui. I was away from office so couldnt respond you earlier, apologies for that.. I have uploaded file at https://www.dropbox.com/s/1kmh07gh5rmoqub/Sales%20Chart.xlsx Appreciate your usual support :)
  6. W

    Bar charts change colors based on dates selection [SOLVED]

    Thanks dan_I but sorry I am missing something here. Perhaps I couldnt pick what you said as I am a normal excel user or I couldnt explain it clearly:). Apologies for that. Actually I could not understand how a slicer will change color of some of the bars amongst many other... All bars are...
  7. W

    Bar charts change colors based on dates selection [SOLVED]

    Dear Excel Gurus!! I need help relating to bar charts color. The situation is as follows: I have a daily sales bar chart for 6 months. On x-axis are days - Jan 1 to 31, Feb 1-28, Mar 1-31 and so on for six months. Y-axis represents sales data. Now All I need is to click/select/highlight...
  8. W

    Using Excel for kids maths practice

    Hi everyone! I am looking for some excel stuff that could help my kids practicing basic mathemarics. My kid is in grade 5 and would need practice for multiplication, additions, substraction, division, mental maths etc. Can someone help me knowing if there's something available like that?
  9. W

    Growth Indicators on excel charts

    Thank you Prasaddn. Can you please help me know how to post sample files here. Regards Waseem
  10. W

    Growth Indicators on excel charts

    Morning all! I need to draw "growth indicators" in excel charts but somehow I couldnt figure out how to do it. Just to clarify my problem, currently I am using "think-cell" application to create charts in powerpoint that are linked with excel. These charts are convenient but do not give much...
  11. W

    Arranging items in ascending order on a chart in excel 2003

    Thanks a lot Hui. I guess i didnt described the requirement adequately. I can send you my excel sheet for better understanding. Can you please share your email with me? Appreciate your usual support
  12. W

    Arranging items in ascending order on a chart in excel 2003

    Hi everyone. can I arrange all items on x-axis in a chart in ascending order based on values on y-axis? Actually i have a data matrix having various columns of data categories for respective variable in rows. Therefore i cannot sort a particular column in my data series. Instead I want excel...
  13. W

    Customized Borders

    Thanks a million Hui. You are always there to help. Only a couple more issues. The background color that I need is laightest grey shade and the line thickness also needs to be minimum. Would I be able to save this macro be usable in all excel workbooks or just in one file? Should i save the...
  14. W

    Customized Borders

    While doing my routine work on excel, my fav formatting style is that first i fill entire sheet with lightest grey shade, then I draw borders of cells in 3D style. For example for upper and left border I select dark grey color and white for lower and right border. Thats how I get an ENGRAVED 3D...
Top