Chart support for horizontal data
Created originally on Bitbucket by allennat (Nathaniel Allen)
In the examples provided the charts only graph properly if the x-axis and the series are in a vertical orientation.
I was unable to get openpyxl to create charts using data that is oriented horizontally. The intended use for this is multiple data-sets that have about 20 values per series, orienting them vertically will make the excel file output less user readable.
Orienting them horizontally provides for a much better user experience when the data needs to be seen.
When I use the reference to select the cells I want I get a bunch of mini series with 1 or 2 values in it. The chart function believes each column is one series instead of each row selected being a series.