'Add a range of data in a single pass.
The default is to treat each column as a data series.'

def add_data(self, data, from_rows=False, titles_from_data=False):

    if (not isinstance(data, Reference)):
        data = Reference(range_string=data)
    if from_rows:
        values = data.rows
    else:
        values = data.cols
    for v in values:
        range_string = '{0}!{1}:{2}'.format(data.sheetname, v[0], v[(-1)])
        series = SeriesFactory(range_string, title_from_data=titles_from_data)
        self.ser.append(series)
