everything i can find on charting the last 12 months dynamically is based on horizontally oriented data. my data is all vertically oriented so i thought that maybe i could just switch around the offset formula given as an example and that it would work, right? wrong. it didn't, maybe i shouldn't even be using that offset formula, who knows? can someone help? i found a really great example to use http://peltiertech.com/Excel/Charts/DynamicLast12.html. but like i said, it's for horizontally oriented data....please help