Data representation in chart (1 Viewer)

akika

Registered User.
Local time
Yesterday, 21:02
Joined
Aug 7, 2018
Messages
102
hi,

From below query access2016, i need to represent the data (attached) in a chart.
Which chart types can i use to represent the details?

SELECT tbl_customer.customerName, Count(tbl_customer.customerName) AS COUNT_PER_customer, tbl_customer.Status, tbl_customer.SEGMENT
FROM [tbl_customer]
WHERE (((tbl_customer.SEGMENT) Is Not Null))
GROUP BY tbl_customer.customerName, tbl_customer.Status, tbl_customer.SEGMENT;
 

Attachments

  • chart.PNG
    chart.PNG
    10.9 KB · Views: 45

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 12:02
Joined
May 7, 2009
Messages
19,094
you can use Line or Bar.
You may also need to 2 charts for Segment and Status.
 

Users who are viewing this thread

Top Bottom