Dynamic Line chart problem

[umairarshad]

Hello all,

I am sorry if i posted it in the wrong section.

I am working on a data set.

It has pivot table. I make identical table to calculate the Liter per Hr 

Liter per Hr = Sum of Quantity/Sum of Hrs.

I use getpivot data in it.

I also make a line chart using the table.

The problem is when i select any GSE in GSE slicer, the chart goes wrong.

for example I seleted ACU in GSE slicer, the graph becomes wrong.

 when I uncheck #REF! then chart becomes correct.

But everytime, i have to uncheck #REF! whenever i select other GSE or months or station.

I want to display the valid chart only i.e. i do not want to filter #REF! everytime.

Need help.

[Ashish_Mathur]

Hi,

Post your MS Excel questions here - Results in Microsoft 365 and Office - Microsoft Community

[Anonymous]

Hi, @umairarshad 

As far as I know, this formula reports an error when the divisor is null, and this error indirectly affects the results of other slicers and charts:

 

Please start a new discussion via the Office Community so that you can get dedicated support on this issue:

Results in Microsoft 365 and Office - Microsoft Community

Thank you for your understanding.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[umairarshad]

anyone please help

[umairarshad]

I want to exclude #REF! in my chart