Graph format

[CookieMonster76]

Hi

Today is the fist time I have ever used BI, so apologies is this is a simple question.

I am importing data from an excel workbook. It has 5 columns.

The first 4 columns do what I want and I have been able to get some graphics out.

From the 5th column, I am trying to draw a stacked column chart, which has numbers ranging from 5 to 20. However, the chart will only draw based on the count i.e. 1. So they are all the same height.

I don't know if its relevant but the other data fields have a sigma next to them, this one doesn't. I have been back into the original excel document to make sure all the number formats are the same, but it doesn't make any difference?

Any help would be greatly appreciated.

Thanks

Paul

 

[Matt Allington]

Is your fifth column formatted as text or number? Sounds like it could be text