Excel line charts - "Show empty cells as" functionality
Created originally on Bitbucket by Aaron Black
I'm using openpyxl 2.4.8 to generate a set of data points and create a chart from them. There is a substantial amount of open space in the data set, and the resulting graph shows these gaps as the default behavior. Within Excel there is an option to change the display behavior for these empty cells, but I have been unable to find that option within openpyxl.
I've attached screenshots to show the data set and resulting graph with the empty cells displaying as gaps and alternately as connected (the third option as zeroes is not included).
Attachments: Screen_Shot_2017-08-24_at_9.23.01_AMScreen_Shot_2017-08-24_at_9.27.30_AM