Pivot Table displaying my values as 0

[kkenshinz]

Hi all, I am using Pivot tables to create charts.

I have different sets of data but when I include one set of data into the chart under the 'values' field, it only displays 0 or 1. It is as shown in the picture. I want to show the bars as temperature (which is correct) and the humidity as a line chart. In the list of data used to create the pivot table, the humidity data is formatted as percentage e.g '89%'.

Due to confidentiality, I cannot post the data.

Thanks so much!

 

[kkenshinz]

I thought i've shared the link in the post above and I cant edit my post. Here is a sa

mple image of what i see.

[/IMG]