Hi All,

I've tried Google in every combination I can think of with no luck. I'm not sure how to even phrase the problem, but I'm sure it has a solution.

I have a business model with various inputs, the two most important of which are time and price (It's always about time and money). I want to create a chart with the Y-axis showing price and the X-axis showing time which draws a line at profit break-even. For example, if I set Price to $45, then break-even will be at 9 months. At $50, it will be at 10, etc. If I set Time to 6 months, break-even will be at a Price of $40. I would like to draw that line without having to make a manual input for each data point in the chart.

If I could auto-generate a table of Time values for a series of Price inputs so that I could enter the prices I want for the Y axis, and I could generate the corresponding X values, that would be halfway to the chart.

Perhaps there's a way to put a series of numbers in a column under the heading "Time" (say months 1 - 36) and just goal seek for Profit = 0 by changing Price, each time feeding the next number (2, 3, etc.) into the formula. Can that be done with a macro using Goal Seek?

Thanks for any help.