Hello,

How I make that in Excel

three charts and one line?

\1

I know the values of B and D

but only if I draw a line over these three charts or points , I will get the values of A, C and E

Like that
\1

I want that the Excel draw a straight line and calculates the correct values of A, C and E

can anybody make something like this in Excel?

please help me...