Neat Google Sheets Switch Axis
Choose Secondary Axis for the data series Profit Margin.
Google sheets switch axis. If it does not suit you eg. Because you want a line specifically then you have to work the data. On the right click Customise.
Click Switch rows columns. On your computer open a spreadsheet in Google Sheets. In Google Sheets there are two easy ways to transpose data ie switch rows and columns.
Switch rows columns in a chart. Transposing the data means that you change the orientation where the rows become columns and the columns become the rows as shown below. Double-click the chart you want to change.
On your computer open a spreadsheet in Google Sheets. 10 or any other resolution you find necessary and fill the data columns using. I think I finally figured it out.
To change this data click on the current column listed as the X-axis in the Chart Editor panel. At the right click Setup. You can add a second Y-axis to a line area or column chart.
Built-in formulas pivot tables and conditional formatting options save time and simplify common spreadsheet tasks. The first column listed under the X-Axis is the X-axis of the chart and the first column listed under the Series is the Y-Axis of the graph. Getting charts and graphs created in Google Sheets or Excel for that matter has always been somewhat of a wrestling match between what I want the software to do and what the software thinks I want it to do.