List Box Form Control with Multiple selection

[Mohit Mehta]

Hi,

Can somebody share some template in which bar graph is created after selecting multiple items from list box. Is this achievable without macro.

R's
Mohit Mehta

 

[Hui]

Mohit

Firstly, Welcome to the Chandoo.org Forums

The Multi-Select use of List and Combo boxes can only be accessed by using VBA

By the sounds of what your trying to do I'd suggest having a look at using Slicers.

They act as an Interface between Pivot tables and charts and allow the user to select one or more field values for charting all without VBA
Refer:
http://chandoo.org/wp/search/?q=slicers
http://www.excel-easy.com/examples/slicers.html