Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-17-2015, 08:10 AM   #1
sgladie@bgsu.edu
Newly Registered User
 
Join Date: Jul 2015
Posts: 28
Thanks: 7
Thanked 1 Time in 1 Post
sgladie@bgsu.edu is on a distinguished road
Advance Chart

Using Access 2013
Trying to create a chart in Access on a form.
My first question, how do I access the data while in the chart software? I know I can use the properties to get to the query, but double-click in chart, and I cannot locate the data series to manipulate.
Second question: how can I just use the data "as is". It always wants to Sum, Count or do some function. I just want data that I have listed in my query.

I included an attachment. This is the chart I am hoping I can create in Access. I created it in Excel.

Data:
Status: value is either "Ready to Rent" or "In Renovation"
Label: listed the unit#/building
Days: how many days the unit has been in the current status
AvgDays: the average days for each status

The only thing I want to change on the attached chart is having the status show as different colors. So the columns that are "ready to rent" are green, and "in renovation" is in yellow. I could not figure out how to do that even in Excel.

Please help. I have read many threads, started over and over trying to figure this out. Even if I have to write VBA for it. I would appreciate the help!
Attached Images
File Type: jpg chart example.JPG (50.4 KB, 62 views)

sgladie@bgsu.edu is offline   Reply With Quote
Old 07-17-2015, 10:47 AM   #2
spikepl
Eledittingent Beliped
 
spikepl's Avatar
 
Join Date: Nov 2010
Location: San Serriffe
Posts: 6,144
Thanks: 77
Thanked 980 Times in 958 Posts
spikepl is a jewel in the rough spikepl is a jewel in the rough spikepl is a jewel in the rough
Re: Advance Chart

So what is not clear in the videos on youtube or in the Access online documentation about how to make graphs in Access?
__________________

Don't tell us what did not happen.
Do you tell the mechanic about your car "it doesn't work" or vague stuff like:
I couldn't, No joy, To no avail, No go
, Incorrect, Wrong, Seems, Without success, It didn't let me, I/it failed.

Do tell us what did happen
:

I want this ... to happen, I attempted this ..., using this ... code and pressing these buttons, the system did this ... in response, and I got this ... error in this ... line.

Did it help? Pass it forward!

Joys of Access:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

spikepl is offline   Reply With Quote
Old 07-17-2015, 11:02 AM   #3
sgladie@bgsu.edu
Newly Registered User
 
Join Date: Jul 2015
Posts: 28
Thanks: 7
Thanked 1 Time in 1 Post
sgladie@bgsu.edu is on a distinguished road
Re: Advance Chart

It doesn't show LOTS of things - but a few...
-how to access your data while in the Graph software (not by datasheet)
-how to make a particular series into a line instead of a column (like it does in Excel)
-how to make it show just the value 'as is' instead of using a function (sum, avg, etc.)
...should I go on!? For all I have read, watched and listen to, it doesn't sound promising that you can achieve charts in Access like you can in Excel. I am not sure if there is VBA out there that would allow me to create the chart shown in the attachment or not. But I am not too hopeful with everything I have reviewed so far.

sgladie@bgsu.edu is offline   Reply With Quote
Old 07-17-2015, 09:05 PM   #4
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,702
Thanks: 2
Thanked 2,072 Times in 2,027 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Advance Chart

In MS-Access you can do the Graph more or less the same as in Excel.
Post some sample data in Excel or a MS-Access database, (Version 2010), zip it.
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
Old 07-21-2015, 06:37 AM   #5
sgladie@bgsu.edu
Newly Registered User
 
Join Date: Jul 2015
Posts: 28
Thanks: 7
Thanked 1 Time in 1 Post
sgladie@bgsu.edu is on a distinguished road
Re: Advance Chart

The Graph in Access is NOT the same as Excel - at least 2013 isn't. It is limited in what it can do compared to Excel. I researched via Microsoft's website and it seems to be everyone's frustration. Microsoft's answer is the capability of linking Access with Excel and visa versa. I really hope they someday realize that isn't the answer, when you want to keep the whole file together and not have to deal with "paths", and are trying to create a dashboard for clients!
sgladie@bgsu.edu is offline   Reply With Quote
Old 07-21-2015, 08:30 PM   #6
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,702
Thanks: 2
Thanked 2,072 Times in 2,027 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Advance Chart

Quote:
Originally Posted by sgladie@bgsu.edu View Post
...It is limited in what it can do compared to Excel. ..
I have not version 2013 (Excel and MS-Access) so I can neither confirm nor deny this, but what can you do in Excel 2013 that you can not do in MS-Access 2013 in your case?
I asked in my former post after some sample data, do you've any?
And only to be sure, do you want a graph like in your first post?

__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
Reply

Tags
charts

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot get loop to advance pambroben Modules & VBA 3 05-11-2014 01:15 AM
Greetings and thank you all in advance! Raerobertsphoto Introduce Yourself 0 01-13-2013 08:47 PM
Using the Tab key to advance to a new record ted.martin Modules & VBA 5 07-26-2007 12:15 PM
[SOLVED] Advance Query kevspad Queries 4 04-12-2006 03:23 AM
Date Advance chiefretired Queries 8 08-10-2005 08:02 AM




All times are GMT -8. The time now is 03:25 PM.


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