0

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.

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

1 Answer 1

0

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.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.