Hi Guys,

Im looking to see the best way to create a bar chat in VBA. Basically I am looking to have a drop down menu for monthly, Quarterly, 6 monthly & Yearly. These would be in different drop down menus. the other catch is i would have a drop down menu for the supplier over 60 suppliers. the tabs on the sheet are all named after the supplier. Again i would need different variables to achieve this as some times i may only wany a monthly chart, the next time i would need a yearly chart. Is there simple code to creat the chart on the Dashboard sheet im creating. All the data has the same cell values in each of the supplier sheets.

Any help would be greatly appriciated.

Thank you

John