Excel is capable of taking text and data and turning it into a chart or a graph, plotting each individual data point on the graph. Charts and graphs can be used to represent data in the form of graphics. One of the many, many features Excel has to offer to its users is the ability to create charts and graphs. Being as powerful a spreadsheet program as it is, Excel is extremely feature-rich.

In this case it is just necessary to add a y2_axis parameter to the seriesĪnd, if required, add a title using set_y2_axis().Microsoft Excel is undoubtedly the most powerful spreadsheet program available for the Windows Operating System. The secondary chart can also be placed on a secondary axis using the methods set_plotarea () # Insert the chart into the worksheet worksheet. Some of the properties of values axes such as min and max when usedĬhart. The documentation calls out the type of axis to which properties apply.įor a Bar chart the Category and Value axes are reversed:Ī Scatter chart (but not a Line chart) has 2 value axes:ĭate Category Axes are a special type of category axis that give them Min and max properties can only be set for value axes (and Date Axes). For example reverse can be set for either category or value axes while the For example, here are the properties for a category axis:Īs such, some of the XlsxWriter axis properties can be set for a valueĪxis, some can be set for a category axis and some properties can be set forīoth. The Y axis is the valueĪxis and points are displayed according to their value:Įxcel treats these two types of axis differently and exposes different Of the values is evenly spaced and sequential. In the majority of Excel charts the X axis is the category axis and each When working with charts it is important to understand how Excelĭifferentiates between a chart axis that is used for series categories and aĬhart axis that is used for series values.

How to exponent excel graph axis label