Forum Discussion
Alizée Bonamigo
Dec 30, 2017Copper Contributor
Problem with the data table
Hello guys!
I have a problem with the option "Data table". When I select the chart below and that I use "Table", choosing "3,8" as "input cell in column", Excel does not calculate and only duplicate the number 2587 in all the empty cells of the chart.
Do you please have an explanation and a solution for me?
Thanks!
See if the attached file helps. The value in C6 must be a formula that is affected by the changing of A3
4 Replies
See if the attached file helps. The value in C6 must be a formula that is affected by the changing of A3
- Alizée BonamigoCopper Contributor
Hello Wyn Hopkins,
Thank you so much for your help, it works perfectly now whereas I had been struggling for days with this issue!
- No problem, could you mark it as Best Response so that others can find it quicker.
- Bonamigo PascalCopper Contributor
Hello,
perhaps there is an option for this kind of calculation
Pascal