How can I create a chart in excel to show me how many records exist for each date?

For example, if my excel sheet contains multiple rows created every day with the "date" as first column, then I want to see how many rows generated every day in a bar chart.


You can do a pivot graph. Do Insert -> Pivot Table -> Pivot Graph. Select your date as your row and as your value as Count of Date and there you go. Bar chart by date.

  • If I could give you more then one up vote I would.
    – CodeMonkey
    Oct 15 '14 at 17:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.