Solved pie chart design (1 Viewer)

[dadaumpa]

Hi to all
i'm going mad to find how to make this stuff in access, i just post the table in access and the chart that i made in excel but that i want in access, so you can understand

1) my table in access

2) my chart in excel that i would like to make in access using the table up there

i hope someone can help me and prevent the burn of my pc (by myself)

 

[theDBguy]

Hi. Can you post a sample db with test data?

 

[dadaumpa]

Hi. Can you post a sample db with test data?

sure, this is the basic structure

sample database

 

[theDBguy]

Hi. Thanks! I restructured the table and edited the data to make the chart look better. I am not sure if this is what you were asking. Hope it helps...

 

[dadaumpa]

Hi. Thanks! I restructured the table and edited the data to make the chart look better. I am not sure if this is what you were asking. Hope it helps...

many thanks, the matter is that my table has to be structured in that way, i cannot change the design.
is there any way to start from "Tabella1" and get the "investments" table or maybe query? some crosstab query or similar?

 

[June7]

A UNION query can rearrange data to normalized structure. Then use that query like a table (except cannot edit data with it).

SELECT ID, Applicant, [Investment A] AS Amount, "A" AS Investment FROM Tabella1
UNION SELECT ID, Applicant, [Investment B], "B" FROM Tabella1
UNION SELECT ID, Applicant, [Investment C], "C" FROM Tabella1
UNION SELECT ID, Applicant, [Investment D], "D" FROM Tabella1
UNION SELECT ID, Applicant, [Investment E], "E" FROM Tabella1;

 

[dadaumpa]

A UNION query can rearrange data to normalized structure. Then use that query like a table (except cannot edit data with it).

SELECT ID, Applicant, [Investment A] AS Amount, "A" AS Investment FROM Tabella1
UNION SELECT ID, Applicant, [Investment B], "B" FROM Tabella1
UNION SELECT ID, Applicant, [Investment C], "C" FROM Tabella1
UNION SELECT ID, Applicant, [Investment D], "D" FROM Tabella1
UNION SELECT ID, Applicant, [Investment E], "E" FROM Tabella1;

why i loose all my time not posting this stuff here?
THANX!

 

[theDBguy]

why i loose all my time not posting this stuff here?
THANX!

Hi. Glad we could assist. Good luck with your project.