Reports :: Shading Area Between Two Values In A Chart?
Mar 19, 2014
I have show results of scores on a graph but need to show if those scores fall below, in between or above acceptable limits. For example, lets say the acceptable range is between 10.5 and 15.6 but people can scores between 0 and 50. So what I need to do on a report chart/graph is show the actual scores in columns, let access automatically adjust the scale, but have the area between 10.5 and 15.6 on the scale highlighted or coloured or perhaps indicated by two horizontal lines across the chart/graph.
I have a table that shows "DONE" and "REMAIN" for each "AREA" like below:
Code:
AREADONEREMAIN TOTAL AREA1100200300 AREA2200300500 AREA3200700900
Now I like to make a report that shows "DONE" and "REMAIN" in each AREA with pie chart, now I have problem how I have to do this job for the graph, how should be "row source" of chart control. What query needs on this table?
I have a combo box in the header area. The record source, Bound Column are set correctly ( I know because I tested it on a form ). In this instance, the user would select from the dropdown list, the name of a member of staff, based on the click-event, and passing the Staff_ID to a variable, this would be used to filter a recordset/recordsource for the report. However, there is no dropdown ( or arrow on combo - so no name can be selected ) ?
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?
I was wondering, is there a way to shade duplicates in a query? I have a database that contains product formulations. When queried, all the products are listed along with their components like this:
Product A Methanol 67% Product A Water 23% Product A IPA 10% Product B Water 50% Product B P123 50% Product C P45 26% Product C Water 40% Product C Q897 20% Product C T79 14
and so on. Is there a way to shade so that it is easier to see the product grouping? Ex. All Product A shaded, Product C shaded, etc. Would I have to do a make table query? If so, can I shade? Thanks for your help!
I am having issues with checkboxes not holding their value and have been told that this is a known problem that has to do with shading. How do I change my checkboxes so there is no shading?
I have a chart that shows the amount of complaints every month in the last year of a selected costumer. The goal is to see if the amount of complaints from this costumer is decreasing or increasing.
The problem is that some smaller costumers have months without complaints (in real life that isn’t that bad). But my graph only displays a dot for the months were the amount of complaints is not null. This makes that the graph line doesn’t show the complete picture.
I know that I should be able to solve this with an ISNULL expression. I have tried the following SQL code as Row Source of the graph: SELECT (Format([Complaintdate],"MMM 'YY")), ISNULL(Count([Complaintnumber])),0 AS [CountOfComplaintnumber] FROM [Complaints] WHERE [Complaintdate] > (Date() -365) AND [Costumername] = Forms!Report_complaintscostumer!Combocustumername GROUP BY (Year([Complaintdate])*12 + Month([Complaintdate])-1),(Format([Complaintdate],"MMM 'YY")); The result of this is that all the months with complaints now get a 0 value and still the months without complaints aren’t shown.
What am I doing wrong? Could someone help me solve this problem? Any help is greatly appreciated!
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:
So I am adding a chart (on a subreport) to a report that has multiple subreports already. I have gotten the chart to show up correctly on the report, but now 2 of my other subreports are not working. I am being prompted to input parameters for these subreports that used to pull their parameters (between dates) from the main report.
I read somewhere that charts master/child linking doesn't work but I'm not sure if that applies to subreports with charts on them, or just charts in general. I've tried changing the query on the chart subreport a little without luck. Is this likely some glitch thing? Should I keep trying to alter the query or maybe there is some other work around option?
I have a query written that has two numbers. One is the trucking fleet size (63) and the other is the average number of trucks used over a time period (in this example, its 52.2)..I just want to create a pie chart that has 52.2/63. so the pie would be roughly 90% filled.
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...
I can't seem to size any of my charts to 100% of their object's size. I've attached screen shots of a chart in Design View, the chart properties, Chart Design View, and Print Preview. I've tried all of the Size Mode options.
My query has the fields setup ID, Date, Session, Value.In a report I am trying to create a bar chart that shows session names on the y axis and values along the x axis. I want to show 1 chart per ID.However, when I run chart wizard and create my chart I am getting charts for each ID repeating by the number of sessions (number of records in my query).So for example with 3 sessions im getting:
Where the chart is setup the way I want it, but it repeats for each session.how I can get the report to show 1 chart per ID?I tried grouping by ID but didn't seem to work
I am working on a project that is requiring me to hide a subreport that happens to be chart graph, when the chart has no data and my problem is that I cannot seem to get the report to properly hide and show the label behind it when the data is not there. I am in need of a SQL code that will read my blank record source as a zero instead of blank. I have tried Nz, IsEmpty, and IsNull and none of them seem to work.Here is the current SQL code:
SELECT DISTINCTROW Sum(Case_review.ID) AS SumOfID FROM Case_review WHERE (((Case_review.[Type of Issue].Value)="Clinical"));
Here is the current VBA code (which is in event on load) for the main report:
If Me.Rpt_Clinical.Report.HasData = -1 Then Me.Label29.Visible = False Me.Rpt_Clinical.Visible = True Else Me.Label29.Visible = True Me.Rpt_Clinical.Visible = False
I am currently using access 2010 and I have been wrecking my brain to figure out how to display message in place of my charts when there is no data. Currently, whenever the chart has no data to display it just shows a white blank space. I would like to replace that with a message.
linking a report and a subreport (chart). I have uploaded my sample DB. I'm trying to chart all the individuals and three fields for each Home. Both report and subreport are using the same query for the record source. My charts are blank "All_Homes_Individual_Totals". Just use date range 05/01/14, 06/24/14 on my Main form page for the data.
My second question is how would you create a chart to pull by each individual with their monthly totals per Home using "qry_Community_ Inclusion_ All_Homes" with a report and subreport (chart) as above. Report would show the individual's totals by month for each home.
When you create a column chart and then change one of the series to a line, how can you then apply formatting to that line? I've attached a stripped down database showing what I'm trying to do. Series 1 shows individual monthly values (percentages) and series 2 shows the target which is 80% for each month.
The problem is that although I can apply formatting to the column series, I can't see any way of selecting the line series so I can set the formatting I want. I'm using Access 2003, on Win XP Professional, in case that's important.
I can not get a line graph inserted into a report by using the Wizard. I have 2 columns of paired data that I want to graph. I dragged the 2 columns to the "Data" control in the wizard and changed summarizing for both columns from "sum" to "none".
When I look at the report in Print Preview, the data points are stacked vertically in the center of the graph and the "Series" box displays what looks like the data. If I add a Date/Time column as the X-axis, I am told that I have to summarize the data, something I don't want to do.
I've made various selections using the wizard and all fail.
I have a popup form that prompts for a value and has a button defined with an OnClick,OpenReport with a WHERE clause. The value the user enters is placed in the WHERE clause.
The report is generated using a Query and the WHERE clause. I was very surprised -- it works!
Now I'd like to add a chart to the report that represents the information on the report. How can I do this without calling the query again? Can I somehow reference the information that's in the report?
I am having an issue with viewing a report. I have a button set up to show the print preview of the report. There is a chart based on the report's record source, and two sub-reports showing related data. The print preview section however shows the the chart area where it would appear is blank, i.e. there is a white area where the chart should go. There is no error message. The two sub-reports appear correctly. If I go to print the report, however, the chart appears, and it will also appear if I change the view type (e.g. to layout and back again).
I have a bar pivot chart made in a form this load fine, I have the below VBA code in place to control the bar color depending on what the bar show.
Set frms = Forms![OtherCases created by Indv by Month chart].Form.ChartSpace.Charts(0) Dim i As Long With frms For i = 0 To Forms![OtherCases created by Indv by Month chart].Form.ChartSpace.Charts(0).SeriesCollection.Count - 1 With .SeriesCollection(i).Name Select Case Forms![OtherCases created by Indv by Month
[code].....
When I then open the Report this is not working at all each bar just get a random color regardless what the bar show.how to convert the above to fit a Pivot chart form a form that is displayed on a report.
I have created a database that tracks production by individuals. I have also created a report which includes a pivot chart to give the user a chart view of production.
In the pivot filter of the chart I have associate names, where the user can click all, or individual associates, to see individual production.
The trouble I am having is when the user goes to print the chart, it will only print the chart with the "All" filter view. Even if the pivot chart is filtered to one associate, it will print like "All" was checked.
Is there a way to allow the report/pivot chart to only print the production for the individual who is checked within the pivot filter?
I've got a report, which on the screen is three chrts and a page break in between. Page is set up to print landscape.
When I print the report or save to pdf it adds a lot of pages in between 2 and 3. It seems to be of chart no.2 getting smaller and smaller. I've attached a copy of the pdf so you can see what I mean.