I have a TABLE of data, from which I have generated a Pivot Table, when I place an array (column from Table) of numbers in VALUES, Excel is seeing this data as text rather than a number so that I cannot plot is correctly (I wish to show the Field settings as MAX or AVERAGE but can only show COUNT. I am sure that the original data is a number, it is a calculation.
Any suggestions. Am working with Excel Office 365 ProPlus.
Simon
Bookmarks