Hi All,
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
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