change Data layout

[Chimp8471]

i have generated a query in Access and now need to chart this data.

i have tried to chart this in Access and have had very little joy, so i am looking at using Excel to do the job now unless someone can suggest a way of doing this in Access.

my problem:

my query generates data as follows:

but to generate the following graph

I appear to need the data displayed in the following format

is this correct ? if so is there a way to display the data in a list downwards as i have requested?


or can the graph i am requiring be generated in Access somehow?

cheers

Andy

 

[Len Boorman]

Cannot actually see your illustrations but I have generally al=ways managed to generate the chart in Access.

My methodology is to use queries querying queries until I have the data in the final shape,form that I want to chart.

In the final query I will have only the data to be charted. That is very important (to me anyway)

Then use the chart wizard


In the past I have created tables, queries in all sorts of combinations to massage the data to get it exactly ready to chart.

Not saying this is the best or only method but it works for me

Len

 

[CBragg]

I know ive had a few problems with generating graphs from queries.

To get round it ive produced a make-table query and then based the graph on this through the wizard.

 

[Len Boorman]

Whatever method you use I think is fine. I believe that it is important to massage your data before charting and not as part of the charting process.


Len

 

[Chimp8471]

i am simply trying to get 2 columns or 2 rows of data like so:

example:

jan feb mar april Target 2003 2004
23 23 54 23 60 47 34

but not sure how to do this....can it be done,if so how please

i have attached a sample DB with a dummy query which is storing the data i have generated.......

i have also added on a form a picture of the graph i am trying to generate.

cheers

Andy

 

[The_Doc_Man]

As a wild-eyed shot in the dark, look at making a cross-tab query with Month/Year as the grouping option for your date-oriented data, and be sure that your other criteria can be aggregated by sum, average, min, max, or count as appropriate. Do not allow sums to be part of the crosstab. Then use the cross-tab query as your input.

Of course, I could be way off base with this. But this should at least have a shot at your problem.

 

[Chimp8471]

hi, do you have any examples of how to do this,i am extremley new to cross tabs