Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-20-2018, 10:28 PM   #1
akika
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

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;
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
arnelgp
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
Reply

Tags
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
General
Tables
Queries
Forms
Reports
Macros
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