Solved

Axis Titles in an Access Chart

Posted on 2013-01-10
7
326 Views
Last Modified: 2013-01-10
I have a database of trainee evaluations of which the Options are Very Relevant, Relevant or Not Relevant. I am creating a chart in MS Access report and I would like to display all the options on the x axis even if the count is 0 . Currently if you look at the attached file course Id 1 does not have any trainee listing the course as relevant so it does not appear. Course ID 2 has all the values but only because the trainees have selected at least one of each.

Is there a way to make the axis show all possible options even if they are a null value?

Any help appreciated
DBCharts.accdb
0
Comment
Question by:tmckeating
  • 4
  • 2
7 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
...and since you only have one series, you can delete the legend and add the same data to the chart Title
ScreenAccess-EEQ27990845ShowAllFieldsC.accdb
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:tmckeating
Comment Utility
Yes this is what I need but can you give me brief instructions on where I went wrong so that I would be able to replicate it again?  Also I now I have two charts for each course ID I guess I can just delete mine? The charts in Access are not very intuitive.

Regards

Tricia
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 250 total points
Comment Utility
You did not do anything "worn"
The issue of "empty" values not being represented is a common issue.
;-)

But first, to be fair, there may very well be a more efficient way to do what you asked, so please review capricorn1's post as well...

What I did was to create a crosstab query as the source for the report.
This allowed me to put each "Relevance" in it's own column.
One feature of a Crosstab is that you can "Load" the columns with all possible values
See the last line in the Charts Recordsource:
    PIVOT Table1.Relevance In ("Not Relevant","Relevant","Very Relevant");
...with this line I am loading all of the "Relevant" (no pun intended) values in the columns

*However*, creating the chart from this data is the part that gets scary.
Create the query that displays the data in the way you need it.
Create a chart in the Report
Select the query as the source
Pull in all the fields you want
(*Where* you put the fields is something you have to play around with)
But if you drop them in the upper left, you will have to double-click each field and set it to "None", for the summary
There is no way around it, ...This is something you have to do quite a few times until you get it right...
;-)


<Also I now I have two charts for each course ID I guess I can just delete mine?>
Yep,(unless you want to keep it for sentimental reasons...)
;-)

<The charts in Access are not very intuitive.>
I know, trust me..., I know...
;-)

JeffCoachman
0
 

Author Comment

by:tmckeating
Comment Utility
Thanks I did look at Capricorns but the teacher wanted the labels along the x-axis.

Many thanks from "Bonnie Scotland" :-)
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
Se do bheatha
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

771 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now