# Chart based on count of rows at sample date range

1. ## Chart based on count of rows at sample date range

I have a data set with one datetime column.

I'd like to generate a chart that approximates the count of rows over the date range with a low resolution.

I don't mind reading through how to do this, but I am not even clear what the correct approach is so I am kind of lost. I'd be grateful for any pointers!

Thanks.

2. ## Re: Chart based on count of rows at sample date range

You can use a pivot chart and grouped data to count the exact number of rows for each date value - by day, week, month, quarter, year....

So you need to better explain what you actually want, with a simple example.

3. ## Re: Chart based on count of rows at sample date range

Hi Bernie,
That actually helped me understand what to search for.

I created two computed columns with the year and month of each date, created the grouped pivot, then the chart built automatically exactly as I hoped.

Thank you!

4. ## Re: Chart based on count of rows at sample date range

Great! But if you have dates in your table already, you don't need to compute year and month - those are standard groupings available by default.

5. ## Re: Chart based on count of rows at sample date range

Well that would be great to save time and effort, if we assume I have a two-column data set of name to birthday, how do I accomplish this to achieve the same grouping shown in the image?

groups.png

Thank you!

6. ## Re: Chart based on count of rows at sample date range

Simply drag your date field to both the row and data areas - for me, the dates were grouped automatically into year and quarter. All I needed to do was to uncheck quarter, and months became the secondary grouping.

7. ## Re: Chart based on count of rows at sample date range

Brilliant, I did not know about that.

8. ## Re: Chart based on count of rows at sample date range

There are always new things to discover - which is why Excel is both fun and frustrating!

There are currently 1 users browsing this thread. (0 members and 1 guests)