Graph without list

[bingo little]

I have written a worksheet to show the total product price on entering the order quantity. Order quantity is entered in cell c5 and the total price is shown in c15 and price per unit in c16. The total price is obtained after excel looks up the bulk discounts for certain components.
I want excel to draw a graph showing price against quantity ordered. That is to plot c5 against c16 for values of c5 from 1 to 500. Is there an easy (ish) way to do this pls?

[Andy Pope]

You can use a named range if all the points are simple Price*Quantity

The attached will automatically update when you change either Price and or Quantity.

Named range is

'=Sheet1!$D$7*ROW(Sheet1!$A$1:INDEX(Sheet1!$A:$A,MAX(1,Sheet1!$D$9)))

[bingo little]

Andy: Thanks for your answer. I did it in the end by going to “Data” “What if analysis” producing a data table and charting that. Your solution sounded much more elegant.