I've looked at a bunch of forums and a bunch of methods to display last 12 months in a chart, but none of them seem to work for me. Can someone please describe an appropriate way of doing this so that the last 12 months will refresh when data arrives.
This looks good Jerem. What if I wanted to apply a month over month % change? I dont think I can use a stringht column approach because I want the last month that I am showing to have a % change from prior that is not being diaplyed in the chart.