I want to do a What-If Analysis. I have a Bar chart that shows the Sold Volume. Along with the Bar, I want to put another Bar that will be Sum of Sold Volume + Pipeline deals volume.
In the attached file, you will see a listbox that gives my Top 5 deals in pipeline. Below the listbox there's a chart with 2 Bars. The first Bar is my Sold Volume. The Second Bar is a what-if Sold Volume, which is the sum of Current Sold Volume and whatever pipeline deal I select from the Listbox above.
I want to see what will my Sold Volume look if any of the selected deals could be sold.
Please let me know if you need more information. Any help will be greately appreciated.
My problem is little different. This cannot be done with sliders. You see there could be hundreds of deals lying in my pipeline, and I want to select some of them.
eg: I have displayed my Top 10 deals in pipeline in a listbox. Now I want to focus on say Deal numbers 2, 6 and 9. I just select them and they get added to my Chart which already has Sold Volume (check the image). This way i can compare my current Sold Volume, and my new Sold Volume if these 3 deals are sold.