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

    Drop Down box in Graph (excel 2003)

    Any help please
  2. E

    Drop Down box in Graph (excel 2003)

    Also when I try to save your solved file, i lose all the values in the drop down box, place names get converted to #N/A
  3. E

    Drop Down box in Graph (excel 2003)

    Hi Debraj, This is exactly what i wanted. Could you please let me know how you inserted the box in the graph THanks a lot for this
  4. E

    Drop Down box in Graph (excel 2003)

    Hello Friends Please refer attached file. I need to add a drop down menu in the graph which shows the place names and as soon as I select the anems the graph should update. place names are shown in Column A of "Share Summary" sheet in the file Also I would need to make the date columns absolute...
  5. E

    Pie Chart Plot area

    Thanks Narayan. BUt I am not able to drag the PLot Area at all. please see attached excel 2003 file
  6. E

    Pie Chart and Table Query

    THanks Narayan This is really helpful
  7. E

    Pie Chart Plot area

    Pie Chart Plot Area I'm using Excel 2003 and I increase my plot area in my pie chart to reduce the amount of white space in my chart area. When I increase or decrease the chart area it increases and decreases the pie chart too. I just want to increase the plot area. I click on the grey outline...
  8. E

    Pie Chart and Table Query

    Hello Friends, Could you please kindly refer the attached spreadsheet and help me design a Pie Chart and an adjoining table ? -A Drop down menu which has list of SALESMAN Names above the Graph -When I select the SALESMAN names the pie chart automatically updates -Pie Chart should show how much...
  9. E

    Help Design Graph from massive data

    I am using excel 2003
  10. E

    Help Design Graph from massive data

    If anyone could help me design a simple graph taking in to account all the information in the attached file or give me step by step instruction on how to do this would be really great thanks heaps excel dumbo
  11. E

    Multiple IF conditions

    THanks Heaps Sajan and Hui. Worked well.
  12. E

    Multiple IF conditions

    Sorry data shown above is confusing . Please refer the above attached spreadsheet. I am using Excel 2003 Regards, Excel Dumbo
  13. E

    Multiple IF conditions

    Hello friends, please help advise a formula Customer Name Revised Customer Name Desired Answers Sigma India Pvt Sigma Sigma New Zealand Sigma API New Zealand...
  14. E

    Lookup values from pivot table

    thanks narayan to get your help again. I am using 2003 version of excel and i guess the formula you provided is for 2010. I will soon update to 2010 , i think i am falling behind the advanced capabilites of Excel 2010. I guess there wont be an answer for 2003
  15. E

    Lookup values from pivot table

    Any help please ?
  16. E

    Vlookup formula query

    thanks HUI. appreciate your help.
  17. E

    Vlookup formula query

    Hi, please see this formula VLOOKUP($C64,'Actual Sales'!$B$162:$K$186,2,0) i would like to know if it is possible to get the referencing column "2" in the formula automatically changed to "3" as i drag the formula sideways right now, i am manually changing the "2" in the formula to "3", "4" ...
  18. E

    Lookup values from pivot table

    Thanks Deb, The formula worked for the first name But it did not work for second name "ILC MICKOVSKI" . Please advise I have posted the revised file here http://speedy.sh/JvSnC/LookUP-from-a-Pivot-Table.xls hi dan and xiq, i tried drop box and it is asking me to sign in i am not able...
  19. E

    Lookup values from pivot table

    Hello Friends, Please refer attached excel sheet and kindly suggest a lookup formula referencing a pivot table. I have provided desired answers in the sheet. I was not able to upload on to this forum hence using a file sharing site. please see link...
  20. E

    Index Match Query

    Worked Perfect ! THanks heaps Sir JB 7
  21. E

    Index Match Query

    HI SirJB7 , Thanks you. I am using excel 2003. i tried and it is not working. I am getting #NAME error. Please see attached
  22. E

    Index Match Query

    THanks Sir JB7, you are correct. I manually checked and there was mistake on some of those error. Please see attached file above. I had asked Luke to help me get rid of #DIV error
  23. E

    Index Match Query

    Hi Luke , your formula works perfect. And you have now guided me to build formula for other cells (bottom right description in sheet). Thanks heaps. one last question, how do i get rid of #DIV error, to make it look neat ? Please see attached
  24. E

    Index Match Query

    HI Friends, Could you please kindly refer the attached worksheet and help frame a formula ? I'm guessing index match is a good one to use. If there is anything easier, would be really great. I am using Excel 2003 . Thanks heaps
  25. E

    Look UP using multiple conditions

    Hi, I had posted this query in your old forum and was advised it was moved to this new forum. I could not find it. Hence posting again. please find attached a file where i would like to look up a certain value from a file that is not in order. any help will be greatly appreciated. i have...
Back
Top