draw chart using a formula

[BoB Bedford]

I've to create a chart using a formula instead of value. Is it possible ?

 

[Bernard V Liengme]

Do you mean something like have values a A1:A20 and formulas such as
=2*A1^2+3*A1-7 in column B?
If so just select the cells and plot.
If you want a more complex answer I am sure one of the MVP will provide it
shortly.
Bernard

 

[BoB Bedford]

Hi Bernard,

Thanks for your help

Do you mean something like have values a A1:A20 and formulas such as
=2*A1^2+3*A1-7 in column B?
If so just select the cells and plot.

I've such value:
Nbr amount1 amount2
0 0 -12000
200 400 -4000
300 600 0
400 800 +32000

amount1 = Nbre*2
amount2 = (Nbre*2*20)-12000

I've tried but it doesn't work.

The formula does calculate what is earn for every item

 

[Evan]

See Stephen Bullen's Excel Page

-----Original Message-----
Hi Bernard,

Thanks for your help


I've such value:
Nbr amount1 amount2
0 0 -12000
200 400 -4000
300 600 0
400 800 +32000

amount1 = Nbre*2
amount2 = (Nbre*2*20)-12000

I've tried but it doesn't work.

The formula does calculate what is earn for every item


.

 

[Jon Peltier]

BoB -

Once you've calculated these results, you can easily chart them. Select
the data (include the labels in the top row) and start the chart wizard.
Choose an XY Scatter chart, and Excel will automatically use the first
column as X values, and the other two for two series of Y values.

- Jon