draw chart using a formula

  • Thread starter Thread starter BoB Bedford
  • Start date Start date
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
 
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.
Click to expand...

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
 
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


.
Click to expand...
 
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
 
Back
Top