Pie Chart with List box - Named Ranges

     

    Steps to follow:

     

  • Create Named Ranges
  •  

  • Update Listbox with Names
  •  

  • Select required name from list box to create chart
  •