Pivot and Dates in first row

Experts, I have data with dates along the top row.  When I make a chart, I do not see these dates along the axis like I believe I should.  I would also like to use the built in pivot charting grouping such as group my month.  I am not sure if I can do so though.  I believe dates along the top row creates issues for pivoting/charting?  How to solve?

Please see attached.
Grateful for your help.
pdvsaProject financeAsked:
Who is Participating?
als315Connect With a Mentor Commented:
You have "Automatic" bins in axis properties:
automaticSet it to "category":
pdvsaProject financeAuthor Commented:
Ahh.. Thank you!  Perfect
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.