Data representation in chart (1 Viewer)

akika

Registered User
Joined
Aug 7, 2018
Messages
91
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

arnelgp

error reading drive A:
Joined
May 7, 2009
Messages
8,631
you can use Line or Bar.
You may also need to 2 charts for Segment and Status.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom