Hi,
I have just updated to Office 365 (Windows 10) so I have the latest 2019 version of Excel. When I create a pivot chart, the chart and PivotChart Fields are visible but the sorted data is not visible. I have never had this issue before (Excel 2013). With the older version of Excel, the sorted would data was always visible at the left of screen and would change depending on the sort applied. Any ideas how to display the data in the latest version of Excel?
I would upload an image to show, however there doesn't seem to be the functionality on this blog to do so.
Thanks in advance for your help.
Les
I have just updated to Office 365 (Windows 10) so I have the latest 2019 version of Excel. When I create a pivot chart, the chart and PivotChart Fields are visible but the sorted data is not visible. I have never had this issue before (Excel 2013). With the older version of Excel, the sorted would data was always visible at the left of screen and would change depending on the sort applied. Any ideas how to display the data in the latest version of Excel?
I would upload an image to show, however there doesn't seem to be the functionality on this blog to do so.
Thanks in advance for your help.
Les