Excel for mac line chart add secondary axis

broken image
broken image

This example turns off all gridlines for all axes on Chart1. Charts('Chart1').Axes(xlCategory).HasMajorGridlines = False This example turns off major gridlines for the category axis on Chart1. This example adds an axis label to the category axis on Chart1. If this argument is omitted, the primary group is used. Can be one of the following XlAxisType constants: xlValue, xlCategory, or xlSeriesAxis ( xlSeriesAxis is valid only for 3D charts). SyntaxĮxpression A variable that represents a Chart object.

broken image

Returns an object that represents either a single axis or a collection of the axes on the chart.