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
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
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 RelatedI 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
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 RelatedI 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.
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
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 ..................
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
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
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 RelatedI 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:
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...
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|____
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!
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 RelatedHello,
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
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.
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.
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 RelatedI 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 RelatedIs there a way to have the same printing options for a chart in access as in excel.
View 1 Replies View RelatedAnyone 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 RelatedHello :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)
:) 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.
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.