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 Replies


ADVERTISEMENT

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

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

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

Org Chart In Access?

Jan 11, 2005

Hello,

I am developing a database that requires the entry of multiple levels of corporate structure and would like to be able to show that structure using an org chart.

I know you can create org charts within Word, Excel or Powerpoint, but does anyone have any suggestions on how this might be accomplished using Access? I have searched the web pretty thoroughly and haven't come up with any answers yet.

I am not necessarily apposed to using an additional software package either, but I need to be able to supply it with variables from within Access and have it produce the desired result.

Any help or suggestions would be greatly appreciated.

Booger

View 1 Replies View Related

Chart By Day Of Week

Apr 2, 2005

I am new to Access and I am trying to use a chart in a report to display the injuries by day of week. Sunday thru Saturday. I am using a qry to pull the information from a tbl that we have entered the information into. I would like to use a Column Chart.

The problem is that it will display the day of week alphabetically and not Sunday -Saturday. I would also like the chart to display each day even thou there were no injuries for that specific day.

Any help would be greatly appreciated.

View 1 Replies View Related

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 1 Replies View Related

Pie Chart Formatting

Aug 26, 2013

I have a pie chart in my report, and when i adjust the date, the weights, which are shown in the pie chartt change. Ranging from 0%-30%. how can i format the pie chart, to not show the weightings that are zero in the labels, and in the legend?

View 2 Replies View Related

Altering Chart Properties?

Dec 13, 2005

I have a line chart built in Access. Is there anyway I can change the line colors like I can in Excel? The default fuschia, bright yellow, and bright blue are horrendous.

View 3 Replies View Related

Access Chart Too Low Resolution.

Nov 22, 2006

Is there a way to have the same printing options for a chart in access as in excel.

View 1 Replies View Related

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

Graph/Pie Chart Coloring

Jun 25, 2007

Hello :D I have an issue with Access I was hoping someone could help me on. So I have this pie chart graph with 3 sections, colored red for East, Green for West, and Blue for North. Now the problem is that sometimes, the data that I pull in doesn't have a "West" and therefor doesn't add it to the chart. This, however, throws the coloring scheme off as it assigns colors so that 1 is red, 2 is green, 3 is blue rather than East is red, West if Green, and North is Blue. I'll provide some images so it'll be easier to understand. (Clickable thumbnails)

http://img509.imageshack.us/img509/3600/beforefb5.th.jpg (http://img509.imageshack.us/my.php?image=beforefb5.jpg) http://img514.imageshack.us/img514/4678/aftermo0.th.jpg (http://img514.imageshack.us/my.php?image=aftermo0.jpg)

View 3 Replies View Related

How To Create A Chart From A Query?

Jul 25, 2007

:) Hello,
Can anyone please tell me how to create a graphic (a chart like in excel) based on the result of a query? It's just names and values (2 fileds only)
Thankyou.

View 3 Replies View Related

Calling All Chart Experts

Aug 10, 2007

Dear Access Chart Expert

I have been trying to figure out how I can make the x-axis show month abbreviation names instead of numbers. Please see attached gif.

Currently, I use the Month([DateField]) function to get numbers of the month because if I use Format([DateField], "mmm") to get "Jan, Feb, March" the chart sorts the months in alphabetical order instead of the correct monthly order.

How can I be able to use the Jan, Feb etc... labels and have the chart sort them in the correct month order and not alphabetical order?

Thanks so much...

greatly appreciated.

View 4 Replies View Related







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