Go Back   Access World Forums > Microsoft Access Discussion > Queries

Thread Tools Rate Thread Display Modes
Old 08-20-2018, 10:28 PM   #1
Newly Registered User
Join Date: Aug 2018
Posts: 89
Thanks: 17
Thanked 0 Times in 0 Posts
akika is on a distinguished road
Data representation in chart


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;
Attached Images
File Type: png chart.PNG (10.9 KB, 15 views)

akika is offline   Reply With Quote
Old 08-20-2018, 10:57 PM   #2
Registered User
arnelgp's Avatar
Join Date: May 2009
Location: somewhere out there
Posts: 7,985
Thanks: 64
Thanked 2,543 Times in 2,442 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Data representation in chart

you can use Line or Bar.
You may also need to 2 charts for Segment and Status.
"Never stop learning, because life never stops teaching"
arnelgp is online now   Reply With Quote

charts , general , queries

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Graphical Representation. AnthonyGerrard General 5 04-12-2016 07:46 AM
Converting Excel Data&Chart to Access07 Table/Chart SMay Tables 0 01-19-2009 07:42 AM
Graphical Representation on each Row treva26 Forms 5 11-18-2007 06:51 PM
Protecting a chart but allowing chart data to change? scott-atkinson Excel 2 09-07-2007 06:18 AM
Access data: Graphical representation seengee General 4 08-18-2003 11:14 AM

All times are GMT -8. The time now is 07:13 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World