Solved

Axis Titles in an Access Chart

Posted on 2013-01-10
7
351 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 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38762934
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38763007
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38763084
...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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

Author Comment

by:tmckeating
ID: 38763293
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
ID: 38763869
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
ID: 38764492
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
ID: 38765915
Se do bheatha
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server functions 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 Ac…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

821 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