Sheetal arora quintiles
Add or remove a secondary axis in a chart in Office 2010 When the values in a 2-D chart vary widely from data series to data series, or when you have mixed types of data (for example, price and volume), you can plot one or more data series on a secondary vertical (value) axis. Chart.Axes method (Excel) 04/16/2019; 2 minutes to read +1; In this article. Returns an object that represents either a single axis or a collection of the axes on the chart. Syntax. expression.Axes (Type, AxisGroup) expression A variable that represents a Chart object. Parameters Microsoft Office Excel 2007. Start Excel, and then open the workbook that contains the Excel chart. Right-click the Category Axis that is contained in the Excel chart, and then perform one or both of the following actions: Click Format Axis, and then follow these steps: In the Format Axis dialog box, click Axis Options. May 03, 2018 · I was able to resize in Excel 2016 by removing the axis labels, resizing the chart, and adding the labels back in. Right Click on the axis title and select Labels, Label Position = NONE. Resize your chart. Once resized add the axis title back on (from Axis Options change the label position back to Next to Axis).