Creating A Chart

Apr 17, 2006

I have this database where I track how long an employee has been with the company. I need to make a chart to show this data. I've got a field that calculates how many days the employee is/was with the company. I now need to group them into categories:

Less than 7 days
Less than 1 month
Less than 3 months
Less than 6 months
Less than 1 year
1 - 2 years
2 - 5 years
5 - 10 years
10+ years

Question is...since charts seem to need to pull from only one source how the heck can I the counts for each of those criteria above into one query or table. I've got them all in separate queries right now because I can't figure out if there's any other way.

View Replies


ADVERTISEMENT

Looking For A Chart Creating Tutorial...

Apr 17, 2007

Anyone know a good site w/ help creating charts in Access 2k? I have a few queries id like to display as charts but just playing w/ the chart feature is getting more confusing by the minute. Any tutorial would be great. TIA!

View 1 Replies View Related

Error While Creating Chart From Query

Oct 19, 2007

Wasen't sure whether this is a Reporting thing or a Querie thing as it resides inbetween the two.

Basically (and believe me I thought this would be pretty straight forward!!!!), I am trying to create a chart from a query that returns the occurences of concerns raised each month for a year. The query returns the following:

MthTextExpr1
Jan0
Feb0
Mar0
Apr1
May0
Jun0
Jul1
Aug1
Sep2
Oct1
Nov0
Dec0

In order that the user can specify a year that the chart will be applicable to, there is a field within the query that relies on the input of a year on an unbound text box on a form: [Forms]![frm_concern_frtpage]![Enter Year] is inputted into the critera box of this field.

However, if you try to create the chart it does not like this and just gives the following two error messages. If you enter a value into this text box and run the report containing the chart, it just gives a blank chart!!!!

Why is this error occuring?

I just want months along the X axis and the values from the Expr 1 column to be displayed on the Y axis!

View 5 Replies View Related

Reports :: Creating A Pie Chart Format?

Apr 20, 2013

I have browsed a few forums and am still having trouble creating a pie chart that has the proper layout that I would prefer.

I have created a query that will list the data I would like to organize into a pie chart. The query, when run, will prompt the user for a start date and an end date and then display the data in this form:

EmployeeX | SumofProject hours | SumofDemo Hours | SumofAdministration hours | SumofEtc hours (5 other categories of hours)
EmployeeY | SumofProject hours | SumofDemo Hours | SumofAdministration hours | SumofEtc hours (5 other categories of hours)

OK, now that I have the data in this format I would like to create a report that includes tabs for each employee, each tab will have a pie chart that has one employee and a pie chart showing how their hours are allocated to each task. e.g. tab 1 would have Employee X and the pie chart would show what percentage of this employee's hours was dedicated to project/demo/admin/etc...

View 1 Replies View Related

Creating Chart Using Field Values From The Report

Apr 18, 2007

I have created a report using a query. Further to this, I have added some fields from the query into the report which calculates the sum of records and the count of records.

My problem here is, using the chart wizard, I am only able to select the fields existing in a 'Table' or a 'Query'.

Can anywone help me to create a Bar chart / Pie chart using the fields in the report? :confused:

View 2 Replies View Related

Creating Report With Pie Chart In Access 2010

Nov 25, 2014

I am working in Access 2010, trying to create a report with a pie chart. The pie chart is based on a query (called Count Pie) that calculates three values:

% IS
% NetInf
% IS + NetInf

I go into Create, Report Design and get a blank report in Design View. I select Chart from the Controls tab and follow the Wizard to specify the data source.

I get a pie chart with the right title (Count Pie). I double-click on the chart to open the report Datasheet and insert the correct value names. My pie chart in Design View looks correct. It has the right title and legend, and shows three slices of the pie corresponding to the three values.

I save the report, and go to Print Preview, where I get a pie chart that looks like a single circle; it has no legend, and doesn't show the three values.

Do I need to have the Access 2010 application re-installed?

View 1 Replies View Related

Modules & VBA :: Creating Excel Pivot Chart In Access

Jan 21, 2014

I've written this code in Access to create a pivot chart in Excel. All the code listed is good except for the last line. The last line creates another instance of Excel. I can't figure out what the correct syntax is.

Set xlApp = New Excel.Application
xlApp.Visible = True
Set wb1 = xlApp.Workbooks.Open("c:chi estpivot.xlsx"
wb1.Sheets.Add
wb1.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _

[code]....

View 14 Replies View Related

Reports :: Creating Chart In Report Using Unbound Text Boxes?

Jul 25, 2013

I am having trouble creating a chart within a report. Let me start off by explaing my report.

I have many unbound textboxes on my report that all have the code very similar to this:

" =Count(IIf([Complaints Table]![Month]=1,IIf([Complaints Table]![Decision - Our Favour? (Y/N)]="Y",0))) "

This basically gives a count of for a specific month. There are twelve rows of text boxes and two columns. There is a query applied to the report to input the year, as this is a yearly report.

What I want to do is link a chart to each and every text box to show the data in an easy to view format. But I can't seem to figure it out, and I've had no luck on the web .

View 1 Replies View Related

Reports :: Custom Reports Creating Chart Based On Month Not Calendar Year

Jun 15, 2015

I am editing a database that provides the option of creating custom reports, where the user can input a date range of their choice and receive aggregate data for that time frame. Although all of the numbers in the report are correct, I am having trouble with a chart that I inserted into the report.

Specifically, if the date range requested spans 2 calendar years (i.e. April 2014 through January 2015), the data for January 2015 appears at the beginning of the year (so the chart x-axis is for Jan through Dec, and the Jan 2015 data is showing up in Jan (as if it was 2014, not the end of the given range in 2015). When I try with smaller time frames within a calendar year, it adjusts just fine (i.e. shrinking the window so just March-May is displayed on the graph).

How to adjust the axis so that it properly records the data range- so that it would start the axis with April and end in January, for example?

View 2 Replies View Related

Can Form UseMicrosoft Excel Chart Instead Of Microsoft Chart Wizard

Mar 22, 2006

Hi all,

I'm trying to create a chart in a form, this is not a problem, however, the chart types available are a bit limited compared to if i inserted a Microsoft Excel Chart object.

I'd do that except I'm trying to create a chart based on a query.

Is there a way to make the chart wizard use the Microsoft Excel Chart object as its chart creator so I have access to the chart types available in that object?

any assistance much appreciated.

thanks all.

regards

keji

View 1 Replies View Related

Limit Chart To Date Range / Chart Isn't Updating

Jun 28, 2015

I have a form with a chart , 2 textboxes for start date and end date and a button to filter the data( filter the data by date range) How do i continue from that? The chart isnt updating.

View 5 Replies View Related

General :: Creating A Database For Creating Quotations

May 20, 2015

I am creating a database for creating quotations. The quotation number is generated using the date, for example the first quote today would be quote number "05202015-1" because it is the first one today. The next quote today would be quote number "05202015-2" and so on. Is there a way to make access automatically generate these quote numbers based on the date?

View 3 Replies View Related

Help With A Chart

Oct 11, 2005

I have a stack bar chart that shows hours an event took including delays so its 3 stacked bars. I want to add a goal or target line to the chart but can't seem to keep the bars stack because I have to change the chart type. Any ideas ??

Jon

View 1 Replies View Related

Need Chart Help

Jun 12, 2007

I have a report that is populating from one query. It takes data for a year and groups it by month with the lost time for that month. I am comparing 3 years data 20005, 2006, and 2007. I have set the chart up and it looks good except that my time for each month goes into the data area as a "CountOf" lost time and all months are therefore one. I want to show the lost time for each month. I have tried right clicking on the field in the data area and Autocalc is set to Count, but everything else is grayed out and unavailable. How can I change this setting to just display the value? Thanks in advance for the help.

View 1 Replies View Related

Chart

Dec 5, 2005

I need some help with charts:

I know that the wizard wont allow me to put in more than six fields in the chart. Is there any way that I can get around this???

PivotChart: if i have a field named "Jan", when i put it in the pivot chart or table as a sum, it changes the name to Sum_Of_Jan. Is there any way that i can change this??
thank you.

View 1 Replies View Related

Where Did I See That Chart?

Mar 27, 2006

I once saw in this forum a link to a table that had instructions for referencing forms, controls, subforms and all that good stuff depending on which form you are on. I have searched and searched and I can't retrace my steps to find it again. Could someone please point me to it?

Thanks.

-Dave

View 1 Replies View Related

Chart Help

Oct 18, 2006

What field do I select from my table and where do I place them on the sample
graph in order to get a pie chart showing the correct information?


Details:
I'm trying to insert a chart into a report. Each page of the report is for
a different model name and then breaks down the model into parts:

REPORT:
Model 1
section a=25% section b=30% section c=45% ....

I would like a pie chart to represent the way each model is broken down (one
slice=section a, one slice=section b....)

Here is the table I'm trying to base the charts off of:
section a section b section c
Model 1 25 30 45
Model 2 ..................

View 1 Replies View Related

Chart Query

Aug 19, 2006

I'm currently using MS Access 2000 - When using the chart wizard is there any way of sorting the data by month ? At present I'm getting all my data on one chart but I want to spilt this into seperate months. (ie; 1 chart for July, 1 chart for Aug etc) I know there is the option for choosing 'between dates' but I don't want to have to do a fresh chart every time

Regards

Richard

View 1 Replies View Related

Max 6 Fields Per Chart?

Nov 22, 2006

Hi,

I am trying to add a chart to a form/report which will show sickness for each month (ie. 12 fields).

When I goto insert - chart and start adding my fields Access tells me I'm only allowed six!

What am I doing wrong?

Cheers
Lee

View 3 Replies View Related

Two Plots On One Chart

Jul 16, 2007

I'm paying a programmer a lot of money to make me a financial application with MS-Access 2003.

What I need is a Moving Average superimposed over a Candlestick Chart.

But he tells me Access 2003 cannot perform this miraculous feat..!!

Is there anyone in this or any forum/support group that can verify that it is impossible to have two plots on one graph..???

Please & Thank you
Glenn Pilkey
The Web Group

View 1 Replies View Related

Help With Query For A Chart

Apr 4, 2006

Hey,I have a table with a date of birth field and I need to produce a pie chart showing age groups from this.The groups should be:< 16> 15 < 18> 17Help me!

View 1 Replies View Related

Query For Chart

Nov 20, 2007

I want to make a chart that shows the number of PLANNED CLOSE DATES and the number of ACTUAL CLOSE DATES for each month of the current financial year.
How do I make the Query to base this chart on?

Its been driving me crazy! :confused:

View 2 Replies View Related

Query For A Chart?

Dec 6, 2007

I have a table called Projects
Each project has a Target Close Date
And some have an Actual Close Date

I want to create a chart that has months on the vertical axis (July to June)
and number of projects on the Horizontal axis

Then I want 2 lines on the chart showing how many projects were supposed to be completed and how many actually completed by each month. ie a running total

I think I need to make a query to get the data for this chart, but i dont know how...

View 1 Replies View Related

Basic Chart?

Jul 6, 2005

I have a table with eight fields. I want to do a chart where I the piles are "tighten" togther two and two. I would like the chart to look something like this (Example):

|_______________________________
|___ _ __________________________
|___|x|______ _ ____ _ _____ _ ____
|___|x|_ ___ _| |___|x|_ ____|x|___
|___|x| |___|x| |___|x| |____|x|____
|___|x| |___|x| |___|x| |__ _|x|____
|___|x| |___|x| |___|x| |__| |x|____

View 5 Replies View Related

Chart On Form

Aug 26, 2004

I AM IN A HURRY!!! FRIDAY IS MY LAST DAY!!!!!

I am trying to get a chart to work on a form,

I want the 'Results' to be the data shown (lines),
over the date range (bottom),
with value range (left)

I can't get it to do this though...

can someone please help....

THANK YOU!

View 1 Replies View Related

Chart / Report Help!

Oct 18, 2004

Report repeats the SAME chart for each value on the x-axis (i.e. x-axis is the date and same chart repeats for each month). The chart on the first page is correct and is the only chart I need. How can I change the settings of the chart so the report is the first page???

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved