On the Series Options tab, under Plot Series On, click Secondary Axis and then click Close. A secondary vertical axis is displayed in the chart. To change the display of the secondary vertical axis, do the following: On the Layout tab, in the Axes group, click Axes.Click Secondary Vertical Axis, and then click the display option that you want.o add a secondary vertical axis, see Add a secondary vertical axis. Click a chart that displays a secondary vertical axis. This displays the Chart Tools, adding the Design, Layout, and Format tabs.
https://support.office.com/en-us/article/add-or-remove-a-secondary-axis-in-a-chart-91da1e2f-5db1-41e9-8908-e1a2e14dd5a9
Format the secondary vertical axis (right side of chart) so the horizontal axis crosses at the automatic position (zero). Nobody says you need to keep the original aspect ratio of your chart. You can make it narrower (more so for fewer bars) and taller.irst, format the gridlines to use a lighter shade of gray, and the primary horizontal axis to use a darker shade of gray (but not too dark, no need to use harsh black lines). Format the secondary horizontal axis so it uses the same gray line color as the primary horizontal axis.
http://peltiertech.com/excel-column-chart-primary-secondary-axes/
RonaldoOneNil replied on January 3, 2013. Click to select the Y axis and then right click it and select format axis. At the bottom of the display, it says Horizontal axis crosses. Select the radio button for axis value and enter -40 in the box.26 people found this helpful. have a line graph with percentage values between - 36% and 50 % for various periods. The X axis are the periods and the Y axis is the percentage for each period. When I created a line graph, the X-axis appears in the middle of the graph at value 0%.
http://answers.microsoft.com/en-us/office/forum/office_2010-excel/move-x-axis-to-bottom-on-line-graph/8ff1c352-a7ac-4765-8fa3-02605ed6b4ac
A drop-down menu will appear. Point to Primary Horizontal Axis to view the options for changing the display of the primary horizontal axes. The display options for your primary horizontal axis will be displayed in a menu. Click on the title and description that you want to apply to your primary horizontal axis.Select the Axes button in the Layout ribbon once again and point to Primary Vertical Axis.. Click on a title and description for the display option you want to apply your primary vertical access. drop-down menu will appear. Point to Primary Horizontal Axis to view the options for changing the display of the primary horizontal axes. The display options for your primary horizontal axis will be displayed in a menu. Click on the title and description that you want to apply to your primary horizontal axis.
http://www.ehow.com/how_2272789_change-display-axes-excel.html
To add a secondary vertical axis, see Add a secondary vertical axis. Click a chart that displays a secondary vertical axis. This displays the Chart Tools, adding the Design, Layout, and Format tabs.On the Layout tab, in the Axes group, click Axes.o add a secondary vertical axis, see Add a secondary vertical axis. Click a chart that displays a secondary vertical axis. This displays the Chart Tools, adding the Design, Layout, and Format tabs.
https://support.office.com/en-us/article/add-or-remove-a-secondary-axis-in-a-chart-91da1e2f-5db1-41e9-8908-e1a2e14dd5a9
On the Layout tab, in the Axes group, click Axes, click Secondary Vertical Axis or Secondary Horizontal Axis, and then click None. Click the secondary axis that you want to delete, and then press DELETE. Right-click the secondary axis, and then click Delete.o add a secondary vertical axis, see Add a secondary vertical axis. Click a chart that displays a secondary vertical axis. This displays the Chart Tools, adding the Design, Layout, and Format tabs.
https://support.office.com/en-us/article/add-or-remove-a-secondary-axis-in-a-chart-91da1e2f-5db1-41e9-8908-e1a2e14dd5a9
Excel 2010 chart does not place secondary axis correctly. RAWman asked on July 9, 2011. When I try to add a secondary axis to a chart, it places it to the _left_ of the primary axis instead of at the right of the chart area.Secondary horizontal axis placement is correct (at the top of the chart area).xcel 2010 chart does not place secondary axis correctly. RAWman asked on July 9, 2011. When I try to add a secondary axis to a chart, it places it to the _left_ of the primary axis instead of at the right of the chart area.
http://answers.microsoft.com/en-us/office/forum/office_2010-excel/excel-2010-chart-does-not-place-secondary-axis/7fe51a2d-617c-4dbe-89aa-605bf1f78399
Once the sheet opens, click on your graph to select it. Step 2. Click the Layout tab at the top of the window, then click the Axes button in the middle of the ribbon. Move your mouse over Primary Horizontal Axis and choose More Primary Horizontal Axis Options from the menu that appears.lick on the Layout tab at the top of the Excel window, then click the drop-down arrow on the left side of the ribbon and choose Horizontal (Category) Axis from the list of options. Click the Format Selection button next to the drop-down arrow to continue.
http://smallbusiness.chron.com/change-intervals-xaxis-excel-30030.html
So copy the new data, select the chart, click on the Paste button of the Home tab (the Copy button in 2007!), and add the data as a new series. The data is added to the secondary axis. If the data belongs on the primary axis, simply format the new series and assign it to the primary axis.irst, format the gridlines to use a lighter shade of gray, and the primary horizontal axis to use a darker shade of gray (but not too dark, no need to use harsh black lines). Format the secondary horizontal axis so it uses the same gray line color as the primary horizontal axis.
http://peltiertech.com/excel-column-chart-primary-secondary-axes/
The axis is the measuring scale that is typically placed towards the left and bottom of your chart. Normally, the axis on the left is called the Primary Vertical Axis and the axis placed at the bottom is called the Primary Horizontal Axis.he axis is the measuring scale that is typically placed towards the left and bottom of your chart. Normally, the axis on the left is called the Primary Vertical Axis and the axis placed at the bottom is called the Primary Horizontal Axis.
http://www.indezine.com/products/powerpoint/learn/chartsdiagrams/axes-in-ppt-charts.html
how to make primary horizontal axis at the bottom
To make Primary Horizontal Axis at the bottom click on the title and description that you want to apply to your primary horizontal axis, select the Axes button in the Layout ribbon once again and point to Primary Vertical Axis. The display options for your primary horizontal axis will be displayed in a menu and Click on the title and description that you want to apply to your primary horizontal axis