Solved

MS ACCESS 2013 How to creae a Line Chart from an ACCESS query

Posted on 2014-07-31
14
983 Views
Last Modified: 2014-08-05
Users have been using my MS ACCESS db to track their Performance Measures for over a year.
Now, they have enough periodic data on a given Measure (with corresponding Targets) to begin tracking trends for that Measure, and they want it displayed in their ACCESS program as a Line Chart, similar to what can be done in Excel.
0
Comment
Question by:willjx
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 7
14 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40233309
If you need a step by step list, ...then please post a basic sample of the data.
and also include a basic graphical example of the expected output (based on that data)

The manner in which the data is stored will determine how the chart is created.
0
 

Author Comment

by:willjx
ID: 40234959
Please refer to attached Excel file.
The data is on an SQL server.
However the report and Line Chart will be stored in the ACCESS DB.
--Hhsisi001-aduser--Bill.James-My-Docume
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40235201
Not sure what you uploaded there, but it is not an Excel file I can read...
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40235206
Just upload the file, ...do not rename it
0
 

Author Comment

by:willjx
ID: 40235298
Period Info Collected      Data      Target                  
Oct - Dec 2013                      78.00          81                                       
Jan - Mar 2014                      78.73          81      
Apr - Jun 2014                       80.26          81      


I did not rename it.  I just uploaded it. (again)   Above is the data --Cannot seem to paste in the Line Chart.
--Hhsisi001-aduser--Bill.James-My-Docume
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40235349
I don't know what you are uploading there , ...but I cannot open it, ...and why does it not have a standard Excel extension:  (.xls, .xlsx)
That does not look like a standard excel file name or exptension...???

If you open the link you posted directly:
http://filedb.experts-exchange.com/incoming/2014/08_w31/863963/--Hhsisi001-aduser--Bill.James-My-Docume
...can you open it as an Excel file?

How about just posting a screenshot of the data and the chart?
0
 

Author Comment

by:willjx
ID: 40239555
My work firewall will not let anything thru.
Can't you just give me a hint as to where to start.  It is a simple 3 data vs Target Line point graph?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40239681
Create a new report
Open the report in design view
Insert a chart control
Select your table
Select the Period and Data fields
Select the line chart
Double-click "SumOfData" and change it to: None (the text will change to simply "Data")
Name the report/chart
Resize the chart object to fit the report design page limits
Open the report

Sample attached that you can experiment with.
Database23.mdb
0
 

Author Comment

by:willjx
ID: 40240163
Did 1 and 2
How do you:   "Insert a chart control"?
I inserted an unbound Control, but there is nothing on the 2013 menu that indicates "Chart".
0
 

Author Comment

by:willjx
ID: 40240191
You have a pair of wrenches on your Design tab that my DB does not show.
0
 

Author Comment

by:willjx
ID: 40240213
ok
I found the Graph Control
Selected the Period and Data fields, and
selected the line chart.
I  Double-click "SumOfData" and change it to: None (the text will change to simply "Data").

Named and fitted.

It displays" East and West" legend on side w/"Qtr 1-4" at bottom??, and even though Design shows a line chart, the  Report View just shows two dots in the middle of the screen.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 40240356
<It displays" East and West" legend on side w/"Qtr 1-4" at bottom??,>
...in what view?

Did you try this in the database I posted?
0
 

Author Closing Comment

by:willjx
ID: 40241710
Thank you for your patience.
I finally got it to work with my data.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40241941
Great...

Yes, Access charts can be a bit daunting when you first are learning them.

But once you know the basics, ...it is fairly straightforward...

Remember, you can always create an Excel file with the linked data from Access, ...then create your chart in Excel...
(if that is easier for you)
...and you will have access to all of the new chart options in Excel...


;-)

JeffCoacman
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Menus 6 53
Best way to get data into a database 12 54
Combo box with two columns question 7 36
Error message for incorrect or missing hyperlink 3 26
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question