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

Drop Down box in Graph (excel 2003)

E

Ecel Dumbo

Member
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 as I will keep on adding months to the exisiting file as time goes forward, so when I add months, the graph should also automatically show the new added columsn.
I am using excel 2003

If you could provide a a basic step by step, will be greatly appreciated.

Regards,
Excel Dumbo
 

Attachments

  • Graph Drop Down in Graph.xls
    129.5 KB · Views: 8
Hi Ecel!

Check the attached.. Let us know the feedback..
 

Attachments

  • Graph Drop Down in Graph.xls
    261 KB · Views: 29
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
 
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
 
Hi Joseph ,

I think by now you should be able to resolve this matter.

Deb has used the IFERROR function , which is not available in Excel 2003 ; you know what to do about this. Please do so.

The IFERROR function has been used in column A , on Sheet1 which has been hidden.

Narayan
 
You must log in or register to reply here.
Back
Top