Chart in form with more than 6 field with numbers

[megatronixs]

Hi all,

I´m trying to create a chart inside a form that will take the information from more than 6 fields as that is the max I can add.
I will need to have 36 fields from the database.
I tried to change the query that is procuded by the chart, but still got errors when I copied the fields and refered them to the other field names.

Any one knows how to overcome this?

Greetings.

 

[JHB]

It is only the wizard which is limit to 6 fields.
Create a chart, then change the rowsource after it is created.

 

[megatronixs]

hi,
How do I change the rowsource? in the query or in the chart?
This is actually my first try with charts in Access.

Greetings.

 

[JHB]

Open the form in design view, mark the graph, show the properties choose the data tab, then change the rowsource.

 

[megatronixs]

Hi,

I managed to make some progress.

Big thanks.

 

[megatronixs]

Hi al,

It did not work out :-(
I tried my best, but I can't format the chart as I can with Excel.
Can some one look at my attached test database and let me know where I go wrong?
I attached also a Excel workbook with how I would like it to look like.

Greetings.

 

[JHB]

Your table is wrong set up, the values for A, B, C etc. should be in it's own row, (as you've it in the Excel sheet).
Database attached.

 

[megatronixs]

Hi JHB,

Thanks a lot
That worked, I had no clue that I was doing it wrong.

Greetings.

 

[JHB]

Hi JHB,

Thanks a lot

You're welcome, good luck.

 

[megatronixs]

Hi,

One more question. The append query is needed (query2)? What bout the union query? (Query1). I just try to figure out things.

Thanks and greetings.

 

[JHB]

It was used to show you how the data should be!
If you've tables like "tbl_target_year" in your database you've to redesign the database and the table structures.
Google for "Normalization of data example"