Create A Chart On A Form
i have about 1500 records in my database and i want to display a bar chart for each record, i can tryed creating one but when i try adding the months it says i only can add 6 fields but i want to include each month not just 6 months in the chart, this is an on going database so in the future there will be more months added. here is the picture of the form i want to be able to show 2005 and 2006 figues in the same chart
View Complete Forum Thread with Replies
Related Forum Messages:
Can Form UseMicrosoft Excel Chart Instead Of Microsoft Chart Wizard
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 Replies !
Can I Create This Excel Chart In Access?
Dear Access Expert I am trying to create the Excel chart see attachments (ExcelChart.jpg) in MS Access but I don't think it's possible with the Access Wizard because it doesn't allow me to use more than one data field (step 2 in the Chart Wizard) I created the Excel Chart using a pivot table in Excel with two data fields and they are graphed simultaneously For the Access Chart I only managed to get the "Total Delay Series" and not the "Arrival Delay Series." Must I use Excel to make this complex chart and link it to my Access form and if so can the chart still be dynamic? My intention is to set parameters using combo boxes and then create the chart on the fly. For example currently the user sees the series for the years 2004- 2008. I want to enable the user to be to have a choice about what years (range) they want to view. THank you so much.
View Replies !
Help To Create Inventory Table For A Chart
I am in Access 2003 and I need to create a chart of the inventory levels of a product. I have the daily production and I know that the amount distributed out of the warehouse will be the amount produced that day up to 200 items. However, I can't figure out how to keep a running balance of 'ending inventory' if the amount is over 200, so that it would be the next day's beginning inventory. I am trying to figure this based on the formula: beginning inventory + new production - distribution = ending inventory day 1 day 1 ending inventory (beginning inventory) + new production - distribution = ending inventory day 2 etc I wrote a query to put the new production and the daily balance to retain in inventory (the lesser of daily production or 200). I need my query to be run so that I can put it into a chart, so I need a column to be 'ending inventory' by day so that I can have a line chart going across time. Thanks for any help. I'm stuck.
View Replies !
Using The Chart Wizard To Create A Graph
When I use the Chart Wizard to create a chart it looks fine in the preview but when i change it to form design - to alter the fonts etc- it gives me a graph which looks as if it comes from the Northwest database. What on earth is going on??? PS Am i best using graphs in reports or Pivot charts
View Replies !
Chart On Form
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 Replies !
Thermometer Chart On Form
I am using a one column chart on a form (unbound object) which references a query that sums a field in my table that tracks monetary amounts. As I enter records and go to the next record the chart does not update. It only updates when I close and then open the form. Has anyone had experience using this type of chart on a form and had it update after each record was entered? Thanks
View Replies !
Dynamic Chart In Form
This seems like it would be a simple thing to do but I can't seem to set the properties for a chart (that I inserted into a form) to display the values in that form. The wizard makes it sound like it is very simple and all you have to do is show which fields in the form are related to which field in the chart, but this is not the case at all! Is the chart complete garbage or is there someway to link a chart in the data-entry form to a couple values in that form??
View Replies !
Access Form, Excel Chart, And VBE
hi, I have a probem: I have an application program like below: The program uses forms and VBE of Access. In the VBE, the program generates some data curves in an Excel chart, then incorporates the Excel chart into an Access form. It used to work all right, but now didn't: Just not to display the form! I cheked the Excel chart file and the data curves are OK, so this means incorporating the Excel chart into the Access form and displaying the access form have a problem. Any suggestion will be highly appreciated!
View Replies !
Process Flow Chart In Form
Hello, I am developing one software in access 2000. Now where i stuck up is... Customer is asking for " process flow chart" (steps in block diagram) the requirement is as below.. Say For a pen there are below operations 1. moulding 2. cleaning 3. polishing 4.assembly Now these flow of operation is to be presented in block diagram. Moulding----> Cleaning-----> Polishing----> Assembly Please suggest me how do I do this in accesss? (in form or report) Thanks in advance Satish Aralkar
View Replies !
Relate Chart To Search Form On The Fly
Hi, I'm having problems relating a pivotchart with search criteria automatically after the search - all on the same form. This will be a nifty trick if it is possible, and I can imagine other uses for a form like this. Without being overly wordy, I attach a mdb in hopes that someone with a bit more skill than I will take an interest and set me on the right track.
View Replies !
Updating An Excel Object (chart) On My Form.
Hi, I have an excel object ( a chart) on my form. On given time intervals the data in the underlying excel worksheet changes, and I want the chart to update on my form. Does anyone have any suggestions. I think I´ve been doing the right thing, but the chart just doesn´t update. Fuga.
View Replies !
|
TRACKER
