I have attached a simple spreadsheet with two columns of data, with the data name in column A, and values in columns B and C.
When the two columns of data are both plotted along the primary access, the data in column C is too small to easily see on the chart, but the chart format is correct.
When I plot column C against a secondary axis, I can see the data on the chart, but now the columns overlap, which I don't want. I want them to be separate columns for both sets of data, as in the first chart.
How do I format the chart so the data in the table is plotted against both a primary and secondary axis, but the columns don't overlap?