Marker: Set the properties of the series marker such as style and Gradient: Set the gradient fill properties of the series. Pattern: Set the pattern fill properties of the series. Line: Set the properties of the series line type such as color andīorder: Set the border properties of the series such as color andįill: Set the solid fill properties of the series such as color. The name can also be a formula such as =Sheet1!$A$1 orĪ list with a sheetname, row and column such as. Name property is optional and if it isn’t supplied it will default to For non-Pie/Doughnut charts it is also displayed in the legend. Property is optional and the chart will just assume a sequential series from The data range can be set using aįormula as shown in the first example above or using a list of values asĬategories: This sets the chart category labels. Values: This is the most important property of a series and is the only Range programmatically, a list with zero indexed row/column values. add_chart ()Īs shown above the categories and values can take either a rangeįormula such as =Sheet1!$A$2:$A$7 or, more usefully when generating the

add_worksheet () # Create a new Chart object. Workbook ( 'chart.xlsx' ) worksheet = workbook.

Excel graph axis label overlap