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

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.
willjxAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
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
willjxAuthor Commented:
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
Jeffrey CoachmanMIS LiasonCommented:
Not sure what you uploaded there, but it is not an Excel file I can read...
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Jeffrey CoachmanMIS LiasonCommented:
Just upload the file, ...do not rename it
0
willjxAuthor Commented:
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
Jeffrey CoachmanMIS LiasonCommented:
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
willjxAuthor Commented:
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
Jeffrey CoachmanMIS LiasonCommented:
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
willjxAuthor Commented:
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
willjxAuthor Commented:
You have a pair of wrenches on your Design tab that my DB does not show.
0
willjxAuthor Commented:
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
Jeffrey CoachmanMIS LiasonCommented:
<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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
willjxAuthor Commented:
Thank you for your patience.
I finally got it to work with my data.
0
Jeffrey CoachmanMIS LiasonCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.