How to show the relationship between sales and cost of sales

Just a basic question on excel graphs.

I need to show the relationship between sales and cost of goods over a period of time.

Y Axis needs to be Cost of Goods & X axis should be Sales.

I need one trend line to show the relationship. Is this possible in Excel?



Please see the attached example.

Appreciate your help.

Hi
try creating an xy scatter chart with your costs on the x axis, and adding a trendline

Hi NickyC

Thank you very much. It worked
see the attached XY SCATTER CHART