listbox populating on userform with named range

Hello Everyone,


1.
want to create a named range range2 and want to set range (b8:f8), (b9:f9) and (b10:f10) under it, this I want to do so that I can use named range range2 as chartrange source. I want to populate revenue(b8:f8), cost (b9:f9) and total (b10:f10) in listbox, so when i select revenue from listbox it should refer to range2 (b8:f8) and accordingly change the chart graph, when i select cost from listbox it should refere to range2(b9:f9) and accordingly change the chart graph shwing cost figures.

Please find the attached spreadsheet with 2 userforms and description of the problem. help is appreciated. Thanks in advance.