I am a serious noob to excel and am just wondering if it's possible to either

a) create a data set using start and end values and applying an incrament.

b) create a chart doing the same.

I'm not familiar with the proper terminology so I'll give an example

The end result I am trying for is a chart with

X axis = 0 to A in incraments of 1 where A is a static, changeable number

Y axis = 0 to B in incraments of 10,000 where B is ((A * 250)+1000)

1st chart line = 1,000 to B in incraments of 250

2nd chart line = 1,000 to B in incraments of 150

Then, if possible, highlight points where B+2400 is a multiple of A.

I'd appreciate any help or advice - note this is not for school or work, it is personal interest only. I am able to create this using PHP/GD but it's time consuming and I'd like to figure out how to do it within Excel but I can't seem to find any options/info to do what is required. I suspect it's something to do with XY scatter charts and trend lines.

Is this possible?

Thanks!

JMJimmy