Set up scatter charts for excel spreadsheet

I have a simple tabulated spreadsheet with a few formulae and entry columns. I want to establish a series of scatter charts that individually tag and label data points from the spreadsheet in a range of different column inputs. In total, there are 4 alternative X axes (including a few with numerical+ text input) and 3 different y axes (2 numerical and one percentage). It is important that the charts are flexible as the data will need to be edited and I will need to be able to add additional rows in the future. Presentation format required is only basic Likely to be follow up work.