Jul 07 2020 02:24 AM
I have a pivot table and need to calculate a division of B column by C column (e.g. =B4/C4).
Since I need to build a chart on this calculation, I simply copy a value from A and do the calculation.
The range is not known in advance, that's why I have a formula extended to 1000th row, which shows only relevant values.
Now, when I create a line chart for D5:E1000, it ignores values from D column, but if I select D5:E32, the chart is created.
What's the reason of the issue?
As a workaround, I created another pivot table based on data copied from first pivot table.