WebAnswer: First, select the Insert tab from the toolbar at the top of the screen. In the Charts group, click on the Column button and select the first chart (Clustered Column) under 2-D Column. A blank chart object should appear in your spreadsheet. Right-click on this chart object and choose "Select Data..." from the popup menu. WebMay 22, 2024 · Select the Change Chart Type button to launch the Change Chart Type dialog box. Once the dialog box appears, click on the Combo menu item in the left-side pane. Look for the series you set up to chart the vertical line and ensure its Chart Type designation is changed to Scatter.

Graph with two different vertical scales - Microsoft Community

WebJul 23, 2012 · For the newer versions of Microsoft Excel, the steps are slightly different. STEP 1: Select the Data to be plotted in the chart. You can use this Example Worksheet to practice creating the 2 Axis Chart. … WebMake two y axis in chart. 1. Select the data range, and insert a chart first by clicking Insert and selecting a chart you need in the Chart group. 2. Right click a column in the chart, and select Format Data Series in the … shannon brown facebook

Line Graphs: Examples, Uses, and How to Make Them - Microsoft 365

WebIn this tutorial, I’m going to show you how to add a second Y axis to a graph by using Microsoft Excel. Adding a secondary Y axis is useful when you want to ... WebSep 27, 2024 · For this example, Row 3 will be our secondary axis. 2. Create a chart with your data. Highlight the data you want to include in your chart. Next, click on the "Insert" … WebTo change the point where you want the horizontal (category) axis to cross the vertical (value) axis, under Floor crosses at, click Axis value, and then type the number you want in the text box.Or, click Maximum axis value … shannon brown country singer