Why can't I make a chart? :(

[Gitche Gumee]

I can't seem to fathom the simplest of charts in Access. How do I do it?

Here's my data:

Month Score
June 42
July 50

I want to see this in a column chart that shows a column for June and a
column for July representing the score for the month against a maximum score
of 100.

I can do charts in Excel but am lost in Access. Please help.

Access 2003.

Thanks.

 

[Gitche Gumee]

Here's my rowsource for the chart:

TRANSFORM Avg(qryMilestoneMonthlySummary.AverageScore) AS AvgOfAverageScore
SELECT qryMilestoneMonthlySummary.AverageScore
FROM qryMilestoneMonthlySummary
GROUP BY qryMilestoneMonthlySummary.AverageScore
PIVOT qryMilestoneMonthlySummary.[Milestone Month] In
("January","February","March","April","May","June","July","August","September","October","November","December");

I have created a chart based on this query that I lovingly call
"ChartThatSeemsToWork." It shows all twelve months whether or not there is
data for them. It shows the average score for each month. The Y axis goes
from 0-100 and all is good.

But the columns for each month are not properly spaced. The lower the
average score, the further to the left the column appears over the month name.

I still have no idea what I'm doing. I would appreciate any help.

Thanks.

 

[Duane Hookom]

I'm not sure why you are using a crosstab. I would create a simple totals
query that groups by month and displays the average score. Is there a reason
for the average of an average? If you need all months and the query doesn't
have all months, you could create a table of all months and use a join that
selects all records from the "All Months" table.

--
Duane Hookom
Microsoft Access MVP

Here's my rowsource for the chart:

TRANSFORM Avg(qryMilestoneMonthlySummary.AverageScore) AS AvgOfAverageScore
SELECT qryMilestoneMonthlySummary.AverageScore
FROM qryMilestoneMonthlySummary
GROUP BY qryMilestoneMonthlySummary.AverageScore
PIVOT qryMilestoneMonthlySummary.[Milestone Month] In
("January","February","March","April","May","June","July","August","September","October","November","December");

I have created a chart based on this query that I lovingly call
"ChartThatSeemsToWork." It shows all twelve months whether or not there is
data for them. It shows the average score for each month. The Y axis goes
from 0-100 and all is good.

But the columns for each month are not properly spaced. The lower the
average score, the further to the left the column appears over the month name.

I still have no idea what I'm doing. I would appreciate any help.

Thanks.

I can't seem to fathom the simplest of charts in Access. How do I do it?

Here's my data:

Month Score
June 42
July 50

I want to see this in a column chart that shows a column for June and a
column for July representing the score for the month against a maximum score
of 100.

I can do charts in Excel but am lost in Access. Please help.

Access 2003.

Thanks.

 

[Gitche Gumee]

I'm not sure why you are using a crosstab. <<<

The wizard made me do it.

Basically that's what I have already done. The score for the month is
already calculated in a summary query.

Very simply, I do not know how to get the score for each month to show up in
a chart that lists the months across the bottom and the score in a column
above, with the max score always being 100. What should my rowsource for the
chart look like?

I eventually want to display all the months for a year, whether or not they
have any data. But right now, I do not know how to display the two months and
the two scores that I have. It's a complete mystery to me. I have no idea why
this is so difficult for me.

I'm not sure why you are using a crosstab. I would create a simple totals
query that groups by month and displays the average score. Is there a reason
for the average of an average? If you need all months and the query doesn't
have all months, you could create a table of all months and use a join that
selects all records from the "All Months" table.

--
Duane Hookom
Microsoft Access MVP

Here's my rowsource for the chart:

TRANSFORM Avg(qryMilestoneMonthlySummary.AverageScore) AS AvgOfAverageScore
SELECT qryMilestoneMonthlySummary.AverageScore
FROM qryMilestoneMonthlySummary
GROUP BY qryMilestoneMonthlySummary.AverageScore
PIVOT qryMilestoneMonthlySummary.[Milestone Month] In
("January","February","March","April","May","June","July","August","September","October","November","December");

I have created a chart based on this query that I lovingly call
"ChartThatSeemsToWork." It shows all twelve months whether or not there is
data for them. It shows the average score for each month. The Y axis goes
from 0-100 and all is good.

But the columns for each month are not properly spaced. The lower the
average score, the further to the left the column appears over the month name.

I still have no idea what I'm doing. I would appreciate any help.

Thanks.

I can't seem to fathom the simplest of charts in Access. How do I do it?

Here's my data:

Month Score
June 42
July 50

I want to see this in a column chart that shows a column for June and a
column for July representing the score for the month against a maximum score
of 100.

I can do charts in Excel but am lost in Access. Please help.

Access 2003.

Thanks.

 

[Duane Hookom]

The row source of your chart should look like one record per month with the
value. I don't know how you are storing your dates and if you have created an
All Month table. You can order the Row Source by the Month Number but display
the Month Name.
--
Duane Hookom
Microsoft Access MVP

The wizard made me do it.

Basically that's what I have already done. The score for the month is
already calculated in a summary query.

Very simply, I do not know how to get the score for each month to show up in
a chart that lists the months across the bottom and the score in a column
above, with the max score always being 100. What should my rowsource for the
chart look like?

I eventually want to display all the months for a year, whether or not they
have any data. But right now, I do not know how to display the two months and
the two scores that I have. It's a complete mystery to me. I have no idea why
this is so difficult for me.

I'm not sure why you are using a crosstab. I would create a simple totals
query that groups by month and displays the average score. Is there a reason
for the average of an average? If you need all months and the query doesn't
have all months, you could create a table of all months and use a join that
selects all records from the "All Months" table.

--
Duane Hookom
Microsoft Access MVP

Here's my rowsource for the chart:

TRANSFORM Avg(qryMilestoneMonthlySummary.AverageScore) AS AvgOfAverageScore
SELECT qryMilestoneMonthlySummary.AverageScore
FROM qryMilestoneMonthlySummary
GROUP BY qryMilestoneMonthlySummary.AverageScore
PIVOT qryMilestoneMonthlySummary.[Milestone Month] In
("January","February","March","April","May","June","July","August","September","October","November","December");

I have created a chart based on this query that I lovingly call
"ChartThatSeemsToWork." It shows all twelve months whether or not there is
data for them. It shows the average score for each month. The Y axis goes
from 0-100 and all is good.

But the columns for each month are not properly spaced. The lower the
average score, the further to the left the column appears over the month name.

I still have no idea what I'm doing. I would appreciate any help.

Thanks.


:

I can't seem to fathom the simplest of charts in Access. How do I do it?

Here's my data:

Month Score
June 42
July 50

I want to see this in a column chart that shows a column for June and a
column for July representing the score for the month against a maximum score
of 100.

I can do charts in Excel but am lost in Access. Please help.

Access 2003.

Thanks.