![ms excel for mac and format axis where crosses zero ms excel for mac and format axis where crosses zero](https://www.qtiplot.com/doc/manual-en/pics/custom-curves-labels.png)
Returns or sets the maximum value on the value axis. Returns or sets the major unit scale value for the category axis when the CategoryType property is set to xlTimeScale. True if Microsoft Excel calculates the major units for the value axis. Returns or sets the major units for the value axis. Returns or sets the type of major tick mark for the specified axis. Only axes in the primary axis group can have gridlines.
![ms excel for mac and format axis where crosses zero ms excel for mac and format axis where crosses zero](https://help.tableau.com/current/pro/desktop/en-us/Img/axes5.png)
Returns a Gridlines object that represents the major gridlines for the specified axis. Returns or sets the base of the logarithm when you are using log scales. The distance, in points, from the left edge of the object to the left edge of the chart area. True if the axis or chart has a visible title.
![ms excel for mac and format axis where crosses zero ms excel for mac and format axis where crosses zero](https://www.itu.int/net4/wsis/forum/2020/Files/outcomes/draftcovers/5-WSISStocktakingReport2020.jpg)
True if the label specified by the DisplayUnit or DisplayUnitCustom property is displayed on the specified axis. Returns Null if the HasDisplayUnitLabel property is set to False. Returns the DisplayUnitLabel object for the specified axis. If the value of the DisplayUnit property is xlCustom, the DisplayUnitCustom property returns or sets the value of the displayed units. Returns or sets the unit label for the value axis. Returns or sets the point on the value axis where the category axis crosses it. Returns or sets the point on the specified axis where the other axis crosses. Returns a 32-bit integer that indicates the application in which this object was created. Returns or sets all the category names for the specified axis as a text array. Returns a Border object that represents the border of the object. True if Microsoft Excel chooses appropriate base units for the specified category axis.
![ms excel for mac and format axis where crosses zero ms excel for mac and format axis where crosses zero](https://support.content.office.net/en-us/media/4ecf69ac-8476-4bb8-9438-df706f4928fd.png)
Returns or sets the base unit for the specified category axis. Returns an AxisTitle object that represents the title of the specified axis. Returns the group for the specified axis. True if the value axis crosses the category axis between categories. Returns an Application object that represents the Microsoft Excel application. For more information, see the Axes(Object, XlAxisGroup) method. Group can be one of the following XlAxisGroup constants: xlPrimary or xlSecondary. Type can be one of the following ff constants: xlCategory, xlSeries, or xlValue. Use Axes( type, group) where type is the axis type and group is the axis group to return a single Axis object. The Axis object is a member of the Axes collection. The Scale tab of the Format Axis dialog box.GuidAttribute InterfaceTypeAttribute Remarks (If there is no Format Axis choice, then you did not right-click on an axis in step 1.) Excel displays the Format Axis dialog box. Choose Format Axis from the Context menu.Excel displays a Context menu for the axis. Right-click on the axis whose scale you want to change.(The scale automatically chosen by Excel may not represent the entire universe of possibilities you want conveyed in your chart.) You can change the scale used by Excel by following these steps: While Excel can automatically handle many of the mundane tasks associated with turning raw data into a chart, you may still want to change some elements of your chart.įor instance, you may want to change the scale Excel uses along an axis of your chart. Excel includes an impressive graphing capability that can turn the dullest data into outstanding charts, complete with all sorts of whiz-bang do-dads to amaze your friends and confound your enemies.