I created a Pivot Table in Excel and then from that a chart is created.

I added a 'Excel Web Access' web part to display that chart in SharePoint.

enter image description here

Chart is displayed perfectly. Now I need to filter this data according to 'Joining' column so I selected single value-

enter image description here

And when I hit 'OK' I got below error-

enter image description here

This does not make sense as I have selected one value. This error does not go away until and unless I choose all the values and hit OK.

I have tested this with different Charts and same problem occurs. But in Excel, Charts work fine.

Anyone has any idea what is happening here please share.

  • Why are there two columns for 2010 & 2014? What happens when you select one of those?
    – WhiteHat
    Commented Jul 31, 2015 at 3:04

1 Answer 1


I contacted with Microsoft guys through Office365 forums. They said it is a product level error and required my account information to roll out the update. Once they performed that update, this error was gone.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.