How to select data scale in chart for formatting in Excel?

Question

excel

Hello!
Look, this is the situation:
There is a graph built on a table with 2 columns of data.
In one column (the amount of sales ), the data is measured in hundreds of thousands (200,000, etc.) in the other ( number of goods ), in tens - (98, etc.).

spoiler

Due to such a difference in the values ​​on the graph, the " quantity of goods " scale is not visible and I cannot select it with the mouse button, such as the "sales amount" scale to select the format of the data series and put them on the auxiliary axis with an overlay.

spoiler

Thanks

Answer 1

If you understand the question correctly, and you only need to select a column, then being on the chart, you should have the Format tab.

On this tab, in the current fragment section, you can select the column you need