Hello Everyone,
I am trying to create two listbox on userform, each of the listbox should have same range under it, and based on selection from listbox chart should display the graph, suppose I select revenue (b8:e8) from listbox1 and cost (b9:e9) from listbox2 the chart should show both ranges. I want to create a name ranges for chart range source as range2 for all ranges populating in listbox1 and range3 for all ranges populating in listbox2. Please find the attached spreadsheet and help me. Thanks.
Bookmarks