For some reason I'm unable to rotate the titles of the headers in this series of sparklines.
any help would be appreciated.
I've never been able to get axis titles to rotate. However, you can rotate headers, and in this case a Measure Names/Values chart will get you there, see the attached.
measure names. so simple!
Retrieving data ...