That is understandable for sure.

The data I am trying to portray is just a pricing comparison on various terms (month to month, 1, 2, 3 and 5 year) with 5-6 different companies.

Some of the companies don't have pricing for some of the terms, so I think I can just leave those blank. Is that correct?

I am not sure how to enter the data into a spreadsheet to get it to show on the scatter properly. I want the legend to be the 5 or 6 different companies with a scatter points referencing each of the companies and their associated pricing for each of the term.

For example, company A has pricing on a 1 & 3 year term where company B has pricing for 2 & 3 year term.

How do I enter this into the excel spreadsheet? And what columns and rows so I highlight before choosing the scatter chart.

Hoping this is all somewhat clear!

thanks
Rhonda