Dynamic Bar Chart -- Automatically updates my horizontal and vertical data series

[PortoMarco]

I have a sheet with three graphs on it - a line chart, a pie chart and a bar chart. The line chart and pie chart are perfecto.

The bar chart is problematic.

Situation:

1) I have a data tab. The data tab is grouped in two columns - the first is the "Flag" and the second is the "Return". The Flag is either A,B,C,D and the returns are grouped according to flag.

2) I have a report tab where everything is updated the moment I change the value in K2. K2 holds the reference to the flag. So, if I put in a "D", I have a bunch of tables and charts that automatically update by pulling in all the data in the data tab by searching for flag "D". The only issue is the bar chart. I am left creating this long-*** vertical data series on my report tab; populating numbers from -8 to 8 in 0.10 increments and then using a countif function to count the number of observations found in the data series based on the flag in K2.

Can I automate this (without macros) so that the bar chart knows automatically how to organise the horizontal and vertical axis'?

Thanks

 

[PortoMarco]

hoping im not forgotten

 

[PortoMarco]

I've been forgotten