Hey all,

I am creating a dashboard that has a bar chart that is cascadng with two tiers. The first combo box will be month and the next tier would be drivers. The bar chart would move according to the selection I made in the comboboxes. I am trying to get the bar chart to come out with having the activity dates on the bottom (x-axis) with the amount showing for the multiple dates. Each month has a different number of activity dates with different acmounts. Attached is data and calculations. The tab "original data" is the data that I imported in, The "data2" tab is the data that I reformatted, The "calc 2" Tab is the tab with calculations, and "dash 2" tab is the one where it has comboboxes and where the chart will be. I am stuck on the format to get the chart. I am not sure how to make it work and make the cascading to work with it. The other dashboard that is on it is one that has just a diver by month, you can ignore that one. If you have any suggestions or answers, Please get back as soon as possible.

Thanks,

Erica
oltr.xlsx