Excel graphs with range

[rsales]

Hello,


Can you help me trace a graph?


input a -> number of chairs


input b -> price of the chair


C (total income) -> "Input a" X "input b" = C


D (Real income) -> D = "VARIABLE" X "C"


VARIABLE - can go from 1 to 2500


I need to trace a graph that show's variable vs D (real income)


But how can i trace that graph withou writing 1,2,3,4,5,...2499,2500 in each cell to choose has the range of the graph?


thanks and have a great christmas!

 

[Hui]

Rsales


Firstly, welcome to the Chandoo.org Forums


Yes this can be done

Follow along below

I assume

You are on a worksheet called "Sheet1"

A1: "No of Chairs"

A2: "Price per Chair"

B1: No of Chairs

B2: Price per Chair


Set up 2 Named ranges without the :'s

Var: =ROW(OFFSET(Sheet1!$A$1,,,2500))

RealInc: =Var*Sheet1!$B$1*Sheet1!$B$2


Next Insert a Chart

Select and delete the default series

Right click on the Chart, Select Data

Add a series

Series name: Up to you

Series X values: =Sheet1!Var

Series Y values: =Sheet1!RealInc


Voila

Format chart to suit