Chart (1 Viewer)

georg7

Registered User.
Local time
Today, 15:54
Joined
Sep 3, 2019
Messages
84
hi there,
I want to create a Radar chart. The only way that I know is to create a bar chart and edit it into a Radar chart. If I do it that way my Radar chart don't uses my values of the table.
May somebody can explain me how to create a good Radar chart.

:banghead:


Best regards
georg
 

June7

AWF VIP
Local time
Today, 14:54
Joined
Mar 9, 2014
Messages
5,423
I just did this and radar chart displays my data. Provide some data for testing. If you want to provide db for analysis, follow instructions at bottom of my post. Might want to provide a mockup of desired output. Could use Excel to do that.
 

georg7

Registered User.
Local time
Today, 15:54
Joined
Sep 3, 2019
Messages
84
Thanks June.
I added a screen of my table and the table of my Chart.
It's just the bar chart cause even that isnt working.
Why is there just 1 bar not 3 for each Name? Can I add the other ones?
(I'm complete new in the world of Access)



My main Goal is that the Radar chart Looks like this.(w1.jpg) On the outside are attributes. Red circle means bad, yellow okay and green good. The black line is the current value of the Attribute. Goal is that you can easily see that everything is fine or bad.
 

Attachments

  • tbl1.JPG
    tbl1.JPG
    16.2 KB · Views: 52
  • form1.JPG
    form1.JPG
    18.2 KB · Views: 38
  • w1.JPG
    w1.JPG
    26.4 KB · Views: 45

June7

AWF VIP
Local time
Today, 14:54
Joined
Mar 9, 2014
Messages
5,423
Okay, see if this is what you are looking for, based on the data sample provided.

Query1:

SELECT Table1.ID, Table1.Field1, Table1.S AS Data, "S" AS Cat FROM Table1
UNION SELECT Table1.ID, Table1.Field1, Table1.M, "M" FROM Table1
UNION SELECT Table1.ID, Table1.Field1, Table1.G, "G" FROM Table1
UNION SELECT Table1.ID, Table1.Field1, Table1.t, "t" FROM Table1;

Query2:

TRANSFORM Sum(Query1.Data) AS SumOfData
SELECT Query1.Cat
FROM Query1
GROUP BY Query1.Cat
PIVOT Query1.Field1;

Use Query2 as chart RowSource.


I don't think will be able to get that background color fill shown.
 

georg7

Registered User.
Local time
Today, 15:54
Joined
Sep 3, 2019
Messages
84
Thanks a lot. The querry is perfect filtered.
But my chart still looks like this…
How do I add the other values?(1,1; 1)
 

Attachments

  • chart1.JPG
    chart1.JPG
    16.4 KB · Views: 39

June7

AWF VIP
Local time
Today, 14:54
Joined
Mar 9, 2014
Messages
5,423
Did you change the chart type to Radar?

Then back in Form view, if not seeing Radar, click on the chart and see if that triggers refresh.
 

georg7

Registered User.
Local time
Today, 15:54
Joined
Sep 3, 2019
Messages
84
Now I changed it but there is still just one dateset. Charts in Access are so disgusting…
How do I get the other datasets in the chart?
 

Attachments

  • chart1.JPG
    chart1.JPG
    16.6 KB · Views: 38

June7

AWF VIP
Local time
Today, 14:54
Joined
Mar 9, 2014
Messages
5,423
All I did is what I described and all data is there. Do you have a legend showing 3 series? There are 3 lines on chart but because they have identical data, they are on top of each other. Change a few values in table and see if chart changes. It did for me.
 

georg7

Registered User.
Local time
Today, 15:54
Joined
Sep 3, 2019
Messages
84
It worked!
Thank you, I appreciate it a lot!:)
 

June7

AWF VIP
Local time
Today, 14:54
Joined
Mar 9, 2014
Messages
5,423
Glad you got it. Thanks for the interesting challenge.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 06:54
Joined
May 7, 2009
Messages
19,169
Charts in Access are so disgusting…
why not use Chart in Excel.
put all files in same folder.
 

Attachments

  • Documents.zip
    56.6 KB · Views: 51
Last edited:

Users who are viewing this thread

Top Bottom