Pivot Chart not displaying any data/fields

[collmehank]

Hey guys,

I've used pivot tables/charts before, but for some reason none of the fields I'm choosing are showing up in my pivot chart. I have another file and everything is working fine, but for some reason this excel workbook doesnt want to work. Is there any specific thing I need to click to make it autofill into the chart? Or a type of file it needs to be saved as or anything?

I just tried copy and pasting the data into a new workbook and that didnt work either.

Let me know if you can help!

[stephenloky]

Hello,
Could you please post a sample workbook so we can help you better?

[collmehank]

here is the basic formatting with some stuff taken out. still doesnt work.

hope this helps!

[collmehank]

if you need anything else from me, let me know! thanks in advance for the help

[stephenloky]

You need to add something for the "Values" field. I've added a count of DATE (just add any column that have any value for each field...something you can count...), then I've colapsed some fields to make a clear chart... Attached is the file. Hope you understand it.