If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Updating graphs based on choice in drop-down menu:
Hello everyone,
I am working on a little side-project for school. I would like to include an Excel spreadsheet that updates automatically depending on the selection made in a dropdown menu. The scenario is this: I am a reseller of various goods. My products come from multiple vendors which are located in a variety of countries. I purchase these goods in bulk, markup the price by various percentages, and then resell the goods to multiple customers. I am trying to utilize the power of Excel in order to track the successes and failures of various transactions. A sample of the data I am using, and graphs I created in Photoshop (which I would like the final Excel graphs to look similar to), can be found in an Excel file located he http://www.nwcomputersolutions.net/p...ng_example.xls Any help/advice that anyone can provide is greatly appreciated. Thank you! |
#2
|
|||
|
|||
Updating graphs based on choice in drop-down menu:
Here are a few examples that may get you started:
http://peltiertech.com/Excel/Charts/ChartByControl.html http://peltiertech.com/Excel/Charts/ParallelCoord.html http://peltiertech.com/WordPress/eas...le-line-chart/ http://peltiertech.com/WordPress/sam...rdinate-chart/ http://peltiertech.com/WordPress/dis...interactively/ - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "tim_maciejewski" u50017@uwe wrote in message news:92749701c247b@uwe... Hello everyone, I am working on a little side-project for school. I would like to include an Excel spreadsheet that updates automatically depending on the selection made in a dropdown menu. The scenario is this: I am a reseller of various goods. My products come from multiple vendors which are located in a variety of countries. I purchase these goods in bulk, markup the price by various percentages, and then resell the goods to multiple customers. I am trying to utilize the power of Excel in order to track the successes and failures of various transactions. A sample of the data I am using, and graphs I created in Photoshop (which I would like the final Excel graphs to look similar to), can be found in an Excel file located he http://www.nwcomputersolutions.net/p...ng_example.xls Any help/advice that anyone can provide is greatly appreciated. Thank you! |
Thread Tools | |
Display Modes | |
|
|