Producing a bar chart

I have a table from which I need to produce a bar chart.
Each row in the table has figures for one month. There is a column called
'year' and a column called 'month', which contains 01-12. Many other columns
contain various figures.
I need to produce a barchart for our fiscal year which runs July-June. So
the first month in the chart is always July. For each month I need to chart 2
of the figure columns (Mon and YTD) in the same bar but with different colors.
I looked in Access help but help on charts is very sketchy. Can anyone help?

I think the first step is to create a crosstab query but am unsure what I
need in order to get the 2 columns in each bar.

--Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

Your first step is to figure out how you can create a query with the numbers
you require. Have you done this? If not, please provide more specifics on
your data and what you want in your query results.

--
Duane Hookom
Microsoft Access MVP


"Dorian" wrote:

I have a table from which I need to produce a bar chart.
Each row in the table has figures for one month. There is a column called
'year' and a column called 'month', which contains 01-12. Many other columns
contain various figures.
I need to produce a barchart for our fiscal year which runs July-June. So
the first month in the chart is always July. For each month I need to chart 2
of the figure columns (Mon and YTD) in the same bar but with different colors.
I looked in Access help but help on charts is very sketchy. Can anyone help?

I think the first step is to create a crosstab query but am unsure what I
need in order to get the 2 columns in each bar.

--Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

That's where I'm stuck. I guess I need the columns to be the months of the
fiscal year - which will vary depending which month we are in.
The row would contain the data but I need 2 amounts per month, so I guess I
need 2 rows? I don't know, I looked in Access help but it does not explain
what you need in a query to get a certain chart. And the charting wizard does
not ask the right questions for me to answer.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"Duane Hookom" wrote:

Your first step is to figure out how you can create a query with the numbers
you require. Have you done this? If not, please provide more specifics on
your data and what you want in your query results.

--
Duane Hookom
Microsoft Access MVP


"Dorian" wrote:

I have a table from which I need to produce a bar chart.
Each row in the table has figures for one month. There is a column called
'year' and a column called 'month', which contains 01-12. Many other columns
contain various figures.
I need to produce a barchart for our fiscal year which runs July-June. So
the first month in the chart is always July. For each month I need to chart 2
of the figure columns (Mon and YTD) in the same bar but with different colors.
I looked in Access help but help on charts is very sketchy. Can anyone help?

I think the first step is to create a crosstab query but am unsure what I
need in order to get the 2 columns in each bar.

--Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

You didn't provide the information I asked for. Again "please provide more
specifics on your data and what you want in your query results". Do you have
table and field names? How about some sample data and how you want the
results to look in your query?
--
Duane Hookom
Microsoft Access MVP


"Dorian" wrote:

That's where I'm stuck. I guess I need the columns to be the months of the
fiscal year - which will vary depending which month we are in.
The row would contain the data but I need 2 amounts per month, so I guess I
need 2 rows? I don't know, I looked in Access help but it does not explain
what you need in a query to get a certain chart. And the charting wizard does
not ask the right questions for me to answer.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"Duane Hookom" wrote:

Your first step is to figure out how you can create a query with the numbers
you require. Have you done this? If not, please provide more specifics on
your data and what you want in your query results.

--
Duane Hookom
Microsoft Access MVP


"Dorian" wrote:

I have a table from which I need to produce a bar chart.
Each row in the table has figures for one month. There is a column called
'year' and a column called 'month', which contains 01-12. Many other columns
contain various figures.
I need to produce a barchart for our fiscal year which runs July-June. So
the first month in the chart is always July. For each month I need to chart 2
of the figure columns (Mon and YTD) in the same bar but with different colors.
I looked in Access help but help on charts is very sketchy. Can anyone help?

I think the first step is to create a crosstab query but am unsure what I
need in order to get the 2 columns in each bar.

--Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".