Grouping charts by month, only shows on day.

[Guest]

I have created a report to show temperature data from various locations.
I have data for 3 locations for 4 months.
I grouped the report based on Site Location. When I create a chart, it
shows 3 charts, one for each location and each charts shows 4 months of data.
I added a second group to the report for Date and it is grouped by month.
When I link the chart to date record, I get 12 charts as I would expect (3
Location * 4 Months) but each charts only shows one day.

Any Suggestions?

 

[John Vinson]

I have created a report to show temperature data from various locations.
I have data for 3 locations for 4 months.
I grouped the report based on Site Location. When I create a chart, it
shows 3 charts, one for each location and each charts shows 4 months of data.
I added a second group to the report for Date and it is grouped by month.
When I link the chart to date record, I get 12 charts as I would expect (3
Location * 4 Months) but each charts only shows one day.

Any Suggestions?

Looks like you're grouping by date, instead of by month.

Try putting a calculated field in the query by typing

ChartMonth: Format([Date], "yyyymm")

Use this field for grouping rather than the date field itself.

John W. Vinson[MVP]

 

[Guest]

Thanks John,

That worked perfectly. You have no idea of how manual Excel work will be
replaced by doing this.

Jared

I have created a report to show temperature data from various locations.
I have data for 3 locations for 4 months.
I grouped the report based on Site Location. When I create a chart, it
shows 3 charts, one for each location and each charts shows 4 months of data.
I added a second group to the report for Date and it is grouped by month.
When I link the chart to date record, I get 12 charts as I would expect (3
Location * 4 Months) but each charts only shows one day.

Any Suggestions?

Looks like you're grouping by date, instead of by month.

Try putting a calculated field in the query by typing

ChartMonth: Format([Date], "yyyymm")

Use this field for grouping rather than the date field itself.

John W. Vinson[MVP]

 

[Ed Warren]

Iff'n you'all think that is fun, take a gander at a PivotChart!! (wow!, you
can really have fun grouping dates)

Ed Warren

Thanks John,

That worked perfectly. You have no idea of how manual Excel work will be
replaced by doing this.

Jared

I have created a report to show temperature data from various locations.
I have data for 3 locations for 4 months.
I grouped the report based on Site Location. When I create a chart, it
shows 3 charts, one for each location and each charts shows 4 months of
data.
I added a second group to the report for Date and it is grouped by
month.
When I link the chart to date record, I get 12 charts as I would expect
(3
Location * 4 Months) but each charts only shows one day.

Any Suggestions?

Looks like you're grouping by date, instead of by month.

Try putting a calculated field in the query by typing

ChartMonth: Format([Date], "yyyymm")

Use this field for grouping rather than the date field itself.

John W. Vinson[MVP]