WebSep 8, 2008 · Select your Y data on the worksheet and copy it. Activate the chart then Paste Special > New Series to add a second series. Then right click on a point in the series, select Format Data Series and tick to plot on the secondary axis. With Excel's default markers the second series covers up the first so there appears to be only one series (as ... WebJun 7, 2024 · Click on the second series, or select it from the Chart Elements dropdown on the Format tab of the ribbon (under Chart Tools). Click 'Format Selection' on the Format tab. Select 'Secondary axis' on the 'Format Data Series' task pane. That's all! Example, before and after changing the axis: 1 Like. Reply.
How to add a right hand/side Y axis to an Excel chart? - ExtendOffice
WebClick anywhere in the chart that contains the data series that you want to plot on different axes. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Design tab, in the Data group, click Switch Row/Column. Tips To make additional changes to the way data is displayed on the axes, see Change the display of chart axes. WebOn the Format tab, in the Current Selection group, click the arrow in the Chart Elements box, and then click the horizontal (category) axis. On the Design tab, in the Data group, click … evil earth wind fire song
How to create two vertical axes on the same side
WebJul 28, 2024 · On your initial graph after you added secondary vertical axis add secondary horizontal axis, it will repeat the primary one and will be on the top of the graph. After that select primary horizontal axis, reverse it. Next select secondary horizontal axis, reverse as well. Select secondary horizontal axis and delete it. 2 Likes Reply SomilThakur WebJan 8, 2014 · Add a secondary (Y) axis: Create a combo chart with a secondary axis. When the numbers in a chart you created vary widely from data series to data series, or when … WebApr 23, 2012 · Right-click the selected series and choose Format Data Series. In the Format Data Series dialog box, with the Series Options category selected, choose Secondary Axis, to plot that series on a secondary axis. 10. Now look at the chart in PowerPoint. All of a sudden, you can see the data! 11. But having both sets of data as columns is confusing. evileen military coat