Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Drop down 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 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 |
#2
|
|||
|
|||
Any help please
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down in Graph (excel 2003)
On Wednesday, January 29, 2014 9:12:30 PM UTC-6, Excel Dumbo wrote:
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 +-------------------------------------------------------------------+ |Filename: Graph Drop Down in Graph.zip | |Download: http://www.excelbanter.com/attachment.php?attachmentid=939| +-------------------------------------------------------------------+ -- Excel Dumbo Change your chart location from a chart sheet to an insert on a regular worksheet and then you can insert a drop down tied to a macro to change the series to the group desired. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Graph from a Drop Down List in Excel | New Users to Excel | |||
how do I copy a graph from excel 2003? | Excel Discussion (Misc queries) | |||
how to delete item from Pivot graph(Excel) drop-down menu | Excel Discussion (Misc queries) | |||
Need more detailed graph presentations that what is in Excel 2003 | Charts and Charting in Excel | |||
Can you have a vertical line graph in Excel 2003 | Charts and Charting in Excel |