Sparkline issue with x and y axis

[nmss18]

Hello,
I am working with the following table of data below. I added a sparline column chart and for some reason it seems to calculate the chart along the y axis (change category) instead of the x axis(date range). I don't see where I am able to modify how to change this to display the way I want it to.
If anyone can assist I would sincerely appreciate it.
Thanks,
Nathan



Change Category Feb Mar Apr May Jun Jul
Pre-Approved 4 2 9 5 10 6
Staging 11 31 40 39 54 153
Emergency 153 165 200 216 264 183
Client Driven 168 259 210 196 210 255
Standard 2031 1449 1488 1769 1901 1222
Grand Total 2367 1906 1947 2225 2439 1819 <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->

<!-- controls -->

 

[RoryA]

I think you mean you want the Switch row/column option on the Edit Data dropdown on the Sparkline Tools - Design tab?

 

[nmss18]

Yep, that was it. Thanks much.