Charting

Hi, Is there a way to create a circle, with a size that's dependant on a value? I want to create a report that shows a value over each country on a map. I was going to have a map graphic in the layout, and then put a portal on each country and set as 1 row, starting at row 1, 2, 3 etc for the different areas. I think i could do this with a bar chart - but is there a way to make a circle of different size? Cheers, H

I am trying to get to the bottom of this. I need to make an (apparently) simple pie chart but so far it eluded me. I have this database where a field called "TYPE" can have one of three alphabetic values (CSZ, CA, TRB), I need to make a pie-chart which displays the occurences of the "TYPE" field in a neat pie chart; I've been told in another post to make a summary field to count the occurences and to sort it to make it work which I did but I still didn't manage to make the chart work. Can anyone (please) help me producing this small chart? It's driving me crazy. SampleDB - PieChart.zip

Hello all. I have a problem that may be a step backwards for most of you. Starting in Version 7, I was an active user and developed some almost sophisticated solutions. Over time, my needs for FM dropped and as a result, so has my expertise. My new role in my job requires some charting that would typically be done in Excel. However, I am doing most of the data entry and reporting in filemaker 9. I need to create bar charts and I need a quick way to accomplish this. My current idea, without upgrading to 11, is to create the summary date I need, export it as an excel file with the command to launch the application once the export is complete. Fro…

Can the color within the chart behind the series [not the chart background] be changed for a positive negative bar chart?

Hello, all. Â I am attempting to make a layout in Filemaker that will be a dashboard report of sorts, comparing one time period's sales to a previous time period (user definable). Â I have been able to gather the necessary information and display it as text on the layout with no problem. Â However, what I also want to do is to create a few charts on the page which will display the relationship for a single criteria across the two time periods, but I want to have 4 or 5 of these charts on the page. Â The problem I'm having isn't creating the chart, it's the fact that I can't seem to format the chart - no matter what I do, I end up with a chart that has a ton of wh…

Hello, Is it possible to make the bars in a chart a specific color depending on their value? For example, if the value is less than 25% - the bar is green, if it's between 25% and 50% - the bar is red, etc. Thanks.

I'm trying to learn charting and finding it a lot harder than I hoped. Could anyone post an example of a simple "Stacked Column" chart? I'm thinking of something like say you have a database of Car Sales where each record is 1 car sold. Field 1 is Salesman (Joe, Sue, Fred . . .) -- lets put that on the X-axis. Field 2 is Car Maker (Ford, Toyota, BMW). So I'm wanting a stacked column chart so we can see each Salesman's total sales represented as a column composed of the numbers of cars by each Maker. I've been driving myself nuts sorting on the two fields and trying a quick chart and sub-summary report parts and I just can't see my way there. If s…

I am currently charting a date range within a given year with no problem, but I'm am trying to chart multiple years if the date range spans multiple years. Can't seem to get this one. Thanks for any help. Please see my demo file. Take Care Anthony FMP12 Advanced Mac/PC Dynamically Chart By Year and Month.zip

Dear all, I'm quite a novice to filemaker and I'm facing a disturbing problem with the chart feature. My goal is to create a database where I record the number of products that I've sent during each month of the last year to the different countries where my customers are based. I've also created a Report, that tells me exactly the quantities per country, with a sub-summary (month) and a sub-total that indicates the monthly quantities shipped. The tables are: - Country - Orders * month_orders (join table of orders) * unique_orders (join table of orders) - Orders Line Item - Products Things are becoming tougher know that I want to add a ch…

In the FileMaker Pro 12 Training Series they give a problem of displaying a list of salesmen, each with a bar chart. The problem with the solution is the charts are not scaled to each other so that a salesman with 3 sales has a bar the same size as another salesman with 6 sales. Since all these bar charts display on a page together they don't convey the visual information the way I'd like. My question is how to scale multiple bar charts all to the same scale? Can it be done without adding an extra data series just for scaling?

I have a fairly simple Line chart that displays the results of backgammon sessions, where each data point is the cumulative total of points won/lost over time when I sort by Session Date. Works fine. Displaying the Dates along the bottom is not useful, but what *would* be useful would be to see demarcations where the *Year* changes. I know how I would display just the year for each session data point . . . but is there a way that I could display just the major demarcations where a new Year *begins*? 2008 2009 2010 2011 . . . they would not be evenly spaced, since there are more sessions in…

I'm new to graphs on FileMaker so not sure how this one would work, so any ideas would be very much appreciated. My client has a returns table, anything that is returned is entered into this table with the item title, department, return value and date returned. I needed to produce a report which highlights the value of items returned by department by month. I have done this by doing two sub summaries, first the month (http://help.filemaker.com/app/answers/detail/a_id/790/~/creating-a-sub-summary-by-month), then by the department. This used a count summary field of the return value. This works as expected. But the client would like a line graph which plots t…

Hi, I tried to make a script to copy a graphic (made from a set of data recovered during a 24 hours period) The purpose is to archive one graph for one precise date, to keep a history of that day. I started with the idea to copy the graph at the last entry of the day (script activated on validate data), and paste it in a dedicated container field for that day.. From there I tried several solutions, but none worked... Any bit of help will be very much appreciated.. Regards

I'm creating a reporting section for sales. I'm charting dollar value of sales on a weekly/monthly basis. To accomplish this, I have a list-view layout with sub summary parts grouped by week and a chart in the header which uses the sorted data. The reporting/charts is working as expected, but for weeks where there are no sales, there obviously no data. When I use a line graph, it doesn't necessarily show accurate chronological history. For instance, If I generate a monthly report from January to May and there were zero sales in February, I want to have February item along the x-axis with a zero value. How can I achieve this? I want a calendar as my x-axis values not the d…

Hello everyone, I have two questions: Can I sort each lay-out in a different way by default (I mean that when sb open the lay-out, it is sorted)? And the second question, I can't open PDF with mac preview, I have to download and then open with mac preview. Can I solve it? Thanks for the questions, Bye

Hi, How can I set a different custom color per Y series? Is it possible?? I did not see it but maybe I Missed something... Maybe there is a way to create your own set of colors... I show a temperature graph and I need to set a specific color per series.... tnx :)

Hi I have the following values ​​and I can not bring 5 records by date of creation. Record 1 field 1 A field 2 B field 3 C field 4 X field 5 Y Record 2 field 1 A field 2 B field 3 C field 4 field 5 Record 3 field 1 A field 2 B field 3 C field 4 field 5 A= % B= % C= % X= % Y= % For Pie Chart Thanks I hope your support.

Is it possible to show multiple charts from multiple tables on one layout? I have one chart showing Open Orders, X-Axis is Days Open, Y Axis is # of orders Then I have a chart that shows # orders opened vs # orders Closed, X-axis is year/month, Y axis is # of orders. They are both coming from the same database, but the source data is created differently. but the main question is the first one: Is it possible to show multiple charts from multiple tables on one layout? We might want to put on the same screen Employee performance, and People trained, or specific service performance. I hope that makes sense. Thanks in advance.

Hi there, Has anyone tried to create sparklines in portal rows? With the chart control, the margins (spacing or padding) are to big to be useful in portals. For those who are able to create sparklines, how did you manage to do that? Thanks

Hi to all, How to use Control Chart in FileMaker. If there is any code please provide. Thanks in advance. Find attached screenshot.

Hi everyone, Stumped again and totally new to charting. I have a simple calculation field that gives the difference between two date fields in days, then I have three counter fields that determines which three categories the record will be placed 0 -10 Days, 11- 30 Days, Over 30 Days and three summary fields to display the totals of each category for the found set. I am trying to create a chart using the three different summary fields and I'm not sure how or if I can accomplish this. I have attempted various approaches with no success. Thank you for any help or suggestions. Thanks Again Tony FMP 12 Adv. Mac/Win Summary Chart.zip

Hello everyone, I'm trying to create a chart for the incomes and expenses of a certain customer however the main problem is the 'date' field to use. The database is the following: 1 table for customers 1 table for incomes 1 table for expenses The 'customers' table is related to the other 2. I need to create a date field that can be used for both income and expenses in order to generate the chart. In other words it has to answer to : "Show me all the incomes and expenditures of a certain year...now!" At the moment if I use a calculated date field from the 'incomes' table the line of the expenses appears horizontally straight. Hope it make…

I having difficulty creating a simple line chart for related data in a tab panel. Currently, I have a "grid" of related fields (spreadsheet style, rows/columns) in multiple tab panels. Each tab panel shows a single record. This is done by displaying the related fields in a portal on each tab panel, with each portal set to show only 1 row (row1 = record1, etc). Thus, tabbing through will show one related record at a time. All of this works fine until I want to use a line chart to display the same data. I believe the issue is here: The chart will allow me to display a). the current record, . the current found set, or c). related records. In this case,…

Is it a fact that FMP11A Run Time productions do not support charting. I have some nifty charts in the full version that do not appear in the Run Time versions.

Hello, I'm new in the forum. Sorry for my english... i'm Spanish. I'm creating a DB to manage the energy of my customers. They give me the invoice of the electric company and i put the values in my filemaker database. I have a table with: ID_Customer, Date of invoice and Energy. In the other hand i have a layout called 'clients'. In this layout i have all the information of the client. I want to graph the energy consumed by the client in the last 12 invoices sorted by date. X-axis: date of invoice, Y-axis: energy Thanks in advance.

It must be the season... but my brain is fried and I'm not seeing how to create this line chart. I have a database with two years of orders in it. I'd like to create a line graph that shows the number of orders/month. One line per year. What calculations do I need to create, and what kind of self-joins might I need to create such a table?

I want to chart how many enquiries we have per month in our Contacts table. Each enquiry has a timestamp when the record was made. Can anyone tell me how I can set up a chart to display the number of enquiries for each of the last 12 months? Thanks.

hey guys, I'm trying to create a homepage that display a chart of my records. for example let's say i got a record full of basketball cards. basketball cards have their own entire different table with the fields basketball cards name, year, price, etc. and then i have another table that lists the basketball cards according to their team. in other words, it's a table that has perhaps, a list of entire team and an ID for each team. what i did was i have a relationship BasketballCards to BasketballCards_Teams If I want to create a chart in my home page which has a designated table of its own (a home table) that shows how many cards there are per teams, how wou…

Suppose field A is a calculation field that has a value of 4, and field B is a calculation field that has a value of 1, should I expect a pie chart that shows these two values to show A = 80% and B = 20%? If so, I'm not. The chart is formatted to show data from current record (delimited) as the chart is on a layout that is set to form view. I'm not sure whether the chart works out the percentages automatically or I need to define calculation fields to do this. Thanks in advance.

In the (FM12) file attached, can anyone think of a clever way to limit that chart to only the 5 highest results? chartTest.zip

FM11. I set up a report layout with sub summaries. (underlying database is some 6000 records with 50 fields each) Simply a field representing a list of equip types, a field representing an evaluation code (A B or C) and another to indicate the number of the evaluation codes against the equipment type. (simple count calculation to achieve this total count per group) All in a single sub summary part. This works as expected. If a single equip type has say 5 As, and 2 Bs it is summarised and listed accordingly. eg: Equip Y = 5 x A, and Equip Y = 2 x B displayed as two separate line items. However, when a graph is initiated, regardless of where it is placed…

I have a complicated series of scripts that do record looping from one table to another and sets the data from one to the other, with the set variable and set field script steps. I have set the various windows that need to open to a size of 0, 0 and a position of -50000 and -50000. For some reason, that I can't figure out, they are still showing up as the script and subscripts run. I checked to see if I had any layout triggers on but I don't. I have even created blank layouts for the various tables I need to access in these scripts to see if that did anything, which it didn't. I also have the Freeze window script step enabled in each of the scripts at the beginning. …

After a lot of thinkering I realized that the data in charts are affected by the way the records are sorted, so I made a script to auto-sort data "onLayoutEnter", problem is, on the same layout I have another graph that, in order to be visualized correctly should have been sorted by another field. Now, my question is, is in any way possible to have two different sort-order for each of the two graphs? Or is it the only way to achieve that to make two separate layouts with two separate sort orders? I am asking since the ideal solution for me would be to have all charts on the same layout instead of having to put them all in different layouts.

Hello, I am in a bit of a pickle and I was wondering if someone can help me out. I am working on a database and I need to do some charting based on the values input from a value list (and I absolutely have no clue on how to tell FMP to go ascertain how much of each the user input) and I need the chart to change based on filtering (which is done with a button to exclude certain values based on a certain criteria, e.g. excluding items which I acquired for free or items that went unsold) and I was wondering if that would be possible and how? Any pointers? Thanks in advance. Test.zip

Apologies for my many charting questions -- this is a simple one! I can see how it's useful to have the X-axis scale values labeled at the top of the chart as well as along the x-axis itself . . . sometimes. But surely there's a way to remove it that I just can't see? it seems like overkill to display the scale twice in a chart as small as this one, for instance.

Let's say I have a chart that shows how many Visitors a museum has on each day of the week. I sort by DayOfWeek and put this Field on the X-Axis and a Count summary field on the Y-Axis. Dandy. . . . except that if there were no visitors on a given day, the chart doesn't include that day at all -- you get something like Mon Tues Thurs Fri Sat Sun along the bottom. In this case, and many others, though, you *want* to have 'Weds' included with a 0 data point. But that would in effect be charting the absence of a record. What's the workaround for this? Must be a pretty common need, I'd think?

I have an independant table called "reports". I have a relationship to a "proposals" table that relates to "proposal year". I have another relationship to the same table "different name" that relates to "sold year" (the date the proposals sold. I'd like to have a column chart with (2) Y axis' one for "proposal total" per month and next to it "sold total" per month. I can't see a way to do it with 2 relationships since the chart data area only lets you relate to one table.

I have a pie chart that I'm looking to display percentages of the results of a field called "Reasons for Agreement Approved". ( See Diagram ) I have 36 records and I'd like the pie chart to display the % of the total 36. I'm tried using a delimited list which is the list you see on the right hand side and a Labels list which is basically the same list you see on the right with some added values that have not been chosen yet. When I render the pie chart I get what you see in the diagram. Everything is 5%. What I should see for "PAY API - Int SW Sol." for instance is 18/36 or 50%. Anyone. Dom

I'm setting up various charts for a client and am wondering, beyond allowing them to view these metrics within a Filemaker display, or printing out from a layout designed for that purpose, if there are other means of allowing users to make use of the charts -- for example, in a Power Point or Word document. On my Mac, I'm always happy to just take a screen-shot of the chart and use that image (Is there a built-in screenshot function for PC's?). Using FMP anchors on the chart you can set up a chart so that it can be sized as desired just by changing the window size. Poking around this forum, I saw a three-step process for emailing charts that involved (1) gettin…

Hi I have a DB with fields "year", "university", "world ranking" multiple records with uni1>2004>rank uni1>2005>rank etc uni2>2004>rank uni2>2005>rank etc I would like to chart the yearly change with a multi series line chart. I'm struggling to work out how to do this. As you can see from the screen shot I have the universities ranked but they appear in separate charts and I would like both universities to appear together on the one chart. I've attached a v12 file (sorry if you don't have it) to help understand the format. thanks for any help test.fmp12.zip

I am new to using FileMaker's charting feature and I am having a trouble creating a very simple pie chart. Can someone please tell me how this most basic of basic pie chart examples is done? I have a database with a single table and a single number field: how_much_pizza_did_you_eat If the user enters 25 I want to see 25% of the pie filled in. If the user enters 38 I want to see 38% of the pie filled in, etc

Hi Im trying to create a FM database on press readings I have taken and would normally enter into a Microsoft Excel spreadsheet. Each FM record would need it's own graph using multiple fields on the layout. I probably not explaining this very well so I have attached my FM12 database and my Excel sheet I'm trying to duplicate. Can someone take a look and see if it's possible please. regards Peter DGC.zip

This should be pretty straightforward but I'm not sure how to do it. Say I have a portal with 40 related records, the first 10 records have a significant amount of information that needs to be charted in a value field, but the remaining 30 records have an insignificant amount of information in the value field, say 1 or 2. How can I restrict the amount of records displayed in the portal to the first 10 results and prevent it from calculating the rest of the related information?

I often use summaries with a bar chart where the number of data categories I'm charting vary from one summary to the next. This means sometime bars are very wide with few categories or narrow if a lot. It there any way around this - ie tricking the chart to think there are more - but empty categories? I don't want to add dummy records. Also is there any way to restrict the number of values on the y axis. I only need 0, 50% and 100% not 0,10,20,30,… or worse 0,4,8,12,…which seem to be the defaults depending on the chart size.

Hey everyone, while it's easy to show every other x axis label in a line chart (e.g. with Mod()) I can't figure out how to skip some data point labels on the y axis. When I create empty data rows the chart "cuts" the line, so the values have to be there. Does anyone has a trick on how to do it? To understand the problem better: I have a line chart with a lot of repeating values and just don't need to see every occurrence of the repeated data point label. Thanks in advance.

Hi all, I am trying to draw a Matrix chart as in the image attach but did not find anyway to create that chart after much exploration. Is it possible at all? Thanks. Regards, Alex

Charting with FM is only apparently simple... I have an example FM file with two tables: "names" and "activities" I need to chart ALL the data of activities (quantity for each activity) inside the layout of Names (see attached fm7) You can see that the similar bar chart in activities (layout "Grafico") is fine: it shows all together how many activities there are for each kind. No matter what I try, a similar chart on "Names" does not work. You can see that the closer that I've got is a chart that shows the correct quantities but it doubles the bar for each activity type. Thanks for any help Trevix Names.fp7.zip

I have a table called Date Items that includes a field called Dates. I want to create a chart that uses the values of Dates as the X axis, and then the number of days between records as the Y axis. So, if there are 3 records: 1/1/12, 1/10/12, and 1/21/12, the chart would show three entries. The first date would have no Y value, but the next two would have 9 and 11 as their Y axis values. Is this possible? Thanks.

Hi, Having trouble grasping the charting engine. I have a table with the follow rows: SchoolType | Percent | Year | Total Students MS | 99 | 2010 | 12 MS | 22 | 2010 | 10 HS | 80 | 2011 | 25 HS | 70 | 2011 | 20 I would like a bar chart so that there are two series. The first series would be the MS with data from 2010 & 2011 percent average in two bars and then the HS with data from 2010 & 2011 percent average in two bars I can only get as far as the attached chart. I am stuck figuring out how to chart only the 2010 data as a total and then chart only the 2011data as a total. Help! ZIP of FileMak…

I currently have an excel spreadsheet that displays customer ranking per month and each sheet displays per fiscal year. (For Fiscal Year 2012) _Jan'11_____ Feb'11____March'11_______Average'11____________ Joe`````|```5````````````````3`````````````1```````````````````````3 Jon`````|```4````````````````2`````````````5```````````````````````3.67 Juan```|```3````````````````3``````````````2```````````````````````2.67 In filemaker I have a customer table and a ratings table. So one customer can have many ratings each record being a month. When displaying this as a list, It displays the customer then in a tiered effect it does the ratings. With the …

Hi. I'm trying to make a chart based in a field with 2 values (male/female), to get a simple visual comparison of how many men and women are there in a table that is basically a list of people. I'm new to the program but I can't figure out how to do it. Thanks a lot!

I have a newbie question. Hoping someone can help me out, or point me in the right direction. I have a file with two main databases: 1. employees 2. how each employee does in sales per day. So I have nice lists with a day-to-day sale overview for each employee. Easy to make a chart for each employee - but I would like to do a graphical comparison as well. Now I would like to make a layout where I can compare "Employee #1" and "Employee #2" in a "line chart". The chart would have one lines for each employe showing sales over time. The horizontal x-axis would show dates, and the vertical y-axis would show amounts. The best solution would be a si…

Hi, Is it possible to set two different axis on a graph? I have a table with a serie of dates, that are my X axis (timeline). Every record has a Quantity values, starting from, for example 50 000, and varying upon variation values Some records have variation values, ranging from -1000 to 1000 For examples, the table could have those values for date; quantity; variation: 2012-02-01 ; 50000 ; 0 2012-02-02 ; 50000 ; 100 2012-02-03 ; 50100 ; 0 2012-02-04 ; 50100 ; 0 2012-02-05 ; 50100 ; -500 2012-02-06 ; 49600 ; 0 ... and so on. I would like a graph that shows a line for the variations, and a line showing the Quantity, on the same graph.…

Hi I have a portal in which a field of AREA is setup, now the user enters different areas like : id------activity------area------members-----guests 1------training------london-------4-----------7 2------visits---------china--------3-----------6 3------visits--------london--------5----------2 4------meetings----berlin--------6----------4 5-------meetings---china--------2----------5 Now I wan to make a chart in which I want to see area wise how many total members and guest I have. e.g. Attached chart is an example created in Powerpoint

Hi, I am working on a dashboard and it has some charts as well, The chart is working fine with the bars but I want to also have the values on the bars by which it will be easier to read the figure too. Can anyone please tell me how to show the values on the chart bars.

I've been struggling with something and I don't even know if it's possible to accomplish it in FileMaker. A client has acquired data from the Medicare about outpatient surgical procedures that have taken place over the last several years. The data is available in one table that contains many fields but there are three fields of interest: Year: the year in which the surgical procedure took place Payment Amount: the amount paid for the procedure Facility Type: the type of facility at which the facility took place (there are four possibilities) I've also created a summary field called sPaymentAmount My client wants me to provide a line graph of this d…

Hi, I am a newbie to charting, so excuse my newbie question. I have a table of students, and I sorted the table view adding a summary count creating a nice graph of the gender breakup. Ok, now I would like to make another Pie chart depicting the breakdown of their grades. As soon as I resort the table based on Grades to add a summary count, the Gender Graph goes wonky... as it is no longer sorted. Can I create multiple Pie charts from the same table but each based on a different sort of different fields? Thanks so much in Advance, Maria

Hi, I have a table fill with different measurement values. These values are characterized as object 1, object 2, object 3, etc. I am trying to create a chart in which the data series are sorted by the object. Specifically, I will have 2 charts. One will present the data from MeasurementA and another one from MeasurementB. Each line chart will have multiple y axises (Y1=object 1, Y2 = object 2, Y3 = object3). I am having a hard time separating this information in a script. Can anyone offer any help? Thanks. The table would look something like this. Date Object MeasurementA MeasurementB 10/4/2000 1 134 198 10/4/2001 2 145 …

I have a straight forward pie chart but this is escaping me for some reason. I have a pie chart with 4 fields for data. There will be some instances where one or two of the fields will be zero. How would a calculation look that would exclude the "zero" data so the pie chart labels don't look bunched together? I have a bunch of "is empty" or "if"'s in my head but I must be missing the simpler solution. Thanks in advanced (see attachment to see what I'm talking about)

I want to create a line chart which groups weekly information but I cannot figure it because weeks are strange. I have attached file. It shows how Week of year and week of year fiscal are different even when I use day 1 for fiscal start. And what I consider 'group by week' to produce different results does not match either of them. If I adjust so it matches (see file for year 2011) then it will not match for 2012. If I make it match for 2012 then it does not match in 2011. I do not understand. I have searched three forums and I am really tired. I read that WeekOfYear should not be used and looking at file at 1/1/2011 shows why - only one day is in it. So I am…

Hello all, I'm having a labeling problem creating a chart in my sub-summary part. I have several demographic counts that are already counted (summary field) and converted to percentages (calculation field using getsummary() function) for all my fields of interest. The sub-summary reports are produced when I sort by the field "Case Type". I am trying to create a pie chart in the sub-summary part that shows the distribution of each trait (e.g. male vs. female, race/ethnicity distribution) for records of each case type. However, I keep getting a chart with a different pie slice for each RECORD and not for each TRAIT. That is to say, if I have 500 records of a given ca…

I have a chart per customer, which shows the trailing total for revenue for each customer. My report is based on customer and trailing total. It is accurate and shows the correct values, but I would like the value to be shown in the currency format, same as the source data. Any help appreciated

Hi, Wondering if there is a way to embed an image of a chart I have on a layout in an email. I have not settled on any specific email technique/tool/plugin, so all options are on the table there. Essentially I have a group of users that I need to push some recent historic disk space usage info to. These user will NOT proactively come and check if they are using to much disk space. SO . . . I need to push the info to them. It would be great to show them in a chart right in the email last month or two of info. I have data and the charts working in FMP, but can not think of a way to grab an image of the chart, format an email, and send it. I have looked at a bunc…

I am using FM11 and I have created about 10 small charts that I have put on the same layout. I have published my database and everything works with the exception that my charts will not appear on the web. I don't know if I am doing something wrong, this is my first time using charts. Help please, this is urgent that I get it out on the web for our clients immediately. Thanks in advance

I'm trying to make a simple chart that on the y axis displays the different months of the year, and on the x axis displays a numbers field in my database called Total Gross Commission. I've figured out how to attach (specify) the Total Gross Commission field on the x axis, however I cannot figure out the calculations bit on the y axis. Please help! :)

I have a project where I'd like to create chart layouts that have multiple series. I know I need to add items to the y-axis and write a calculation, but I can't figure out how to write the calculation. Here is the situation: I have a group of applicants to a program (all applicants) Within this, I can search for the accepted applicants (accepted) and the applicants who were denied (denied) There is other information about each applicant in all of their records, for example, the state they're from. I want a bar chart where the x-axis is count of people and y-axis is their state of residence. I can do this. The tricky part is adding more seri…

Hi I would need you help. I have a table that is similar to the one I have outlined in the attached excel file. Based on the data in the table, I could not create a bar chart that resembles the one I inserted into the first sheet. Your help is highly appreciated. Thank you Daniel FM Bar Chart.zip

Hello: I´m a medical doctor. My database help me tracking my patiens and reporting. It´s a very especific database. Is for obstetrics ultrasound. I have a practice table (one register for every ultrasound I do) with the date of the ultrasound, patien ID, gestacional age (it´s a calculation field taking the last menstrual period from a related table) and many measurements. This works great. What I wanted to do is a Chart ploting one measurement (for example biparietal diameter against normal value). I have another table (for example normalBPD ) with the normal biparietal diameters values (we use normal ranges values). This table have a gestational age field, percentile 5…

Hi Everybody, I started working with FileMaker Pro 11, in order to create a film library in there. Everything went well, but I am stuck with a problem now. I would like to generate a Chart + Report, where I can see the numbers of films from each distributor. For example: I have 50 movies from Distributor A, 50 movies from Distributor B .... I would like to have the following result. Distributor A: 50 Movies Distributor b: 50 movies Instead file maker generates a following chart / Report. Distributor A: 1 Distributor A: 1 ...(until 50) Distributor B: 1 ...(until 50) How can I solve that problem. All data are in one tabl…

Hello you smart beautiful and helpful bunch! Don't you just want to spend your valuable time helping a pour smuck with his Chart? I know you do, so here it goes. Say I have a table that has a record for everyday of the month, and each record has a field with a numerical value for how much I exercised that day. In another related table and layout I have a line chart that graphs the days along X and the exercise value along Y. I can get that far, where I run into trouble is when I want to graph more then one month's timeline in the same chart, one on top of the other. When ever I try it just puts the months one after the other. Depending on how I sort it the char…

Buggered if I know how to do this or even if you can. I've been trying to sort it out for 2 days now. I have a global table with a global start and finish date. I've created a relationship with another table (shiftsGraph) where the records from shiftsGraph are restricted to between the global dates, obviously. What I'm trying to do is have a chart summarise the total hours for each day between the global dates. So the actual data looks like this: Monday 10.5 hours Tuesday 40 hours Wednesday 2 hours etc I have a summary field the calculates the total hours and I dayName field but all I can graph using the related table option is a record for each …

Dear all, since several days I pondering about the problem without finding a solution: I have quite same data organised like this: Name A400 A500 A600 ... ABC 10 20 30 XYZ 15 22 13 Now I want to make line charts with having A400-A600 as the X-axis and the field values as Y-values. Inside one record I figured out how to do it by calculating lists for Y and use a list with fixed valus (400;500;600) for X. It works and even allows to have the desired multiple line graphs in one chart. As soon as I want to add another line graph from an other record, they are not one on top of each other as FM uses differen…

Is there a way to set the X-axis to be fixed like the Set Y-Axis option in "format chart" in FM11? For example: Charting Age and Height on a background of a growth chart. If X axis spans 10 cm representing 10 years, if x= 9 years, it should fall at the 9 cm location on the graph. A formula can transfrom age in years to cm on the graph but not force location on the axis. Currently, x=9 can fall at the beginning of the x axis if is the only record and moves along the axis depending on the number of records. basically, treated as a category. Thank you all for the feedback and help

I'm trying to use Conditional Formatting on a pie chart so that if there is no data (i.e. all of the values are zero) the chart will be suppressed. Unfortunately no matter what I do with the fill or text color it still shows up with 33.33% assigned to each slice. Help! Thanks! Justin

I'm still pretty new to charting and I have come up against a problem that seems like it should be a real easy one to solve. I have a database that tracks costs for kitchens that my cabinet shop produces. I'm not having great luck with bar charting CONSTRUCTION BUDGET to EXPENSES TO DATE. When the difference between these values is significant the bar chart does a good job of representing the difference. When the difference between these values is small then the proportional comparison gets whacky. Can anybody look at this attachment and help me make this bar chart behave? Thanks so much. Construction Costs.fp7.zip

Is it possible to construct a pie chart that represents different summary fields? I have a database that tracks components that my cabinet shop produces. One field counts drawer boxes. One field counts doors. One field counts faceframes. I also have summary fields that subtotal drawer boxes, doors and faceframes for a found set. Is there a way to use a pie chart to demonstrate the percentage relationship between the various quantities of doors/ drawer fronts and faceframes? In other words, can I populate a pie chart with values from more than one field? If this is not feasible natively within FM 11 can it be done with an aftermarket p…

Hi.... I am trying to chart my patient's audiogram results with X Horizontal axis contains the value of Frequency of 500,1000,2000,3000,4000,6000,8000 Hertz (by calculation). The Y axis is the intensity of the sound heard by the patient for each frequency with the value ranging from 0 to 100 dB (5 dB differences). Creating this chart is not much a problem. My question: Is it possible to create this chart with X axis on the top, Y axis with the value using line chart shown at the bottom (downward) instead of upward. (Mirror image of ordinary line chart). Thank you for your help

Hi. My Pie chart has 30-50 slices and the last few are under 1%. These values become bunched up. I can use a label calculation to eliminate the name for values under a certain %, however the actual % value still automatically displays. I can think of a few round about ways to fix this, but I was wondering if anyone had a straight forward solution. I would just like the smaller values to be completely blank. See attachment

Is it possible to add textual formatting to the data labels along chart axis other than through the chart formatting dialogue box? As seen in the image I have a chart that is showing two sets of data from different date ranges. The data itself is shown with different colors within the area chart. I would like the "Date" labels along the X Axis to reflect those same colors. As is, I am limited to using some form of separator between the two date values, but this becomes hard to read when looking at more than a few dates at a time. The values for each data point on the X Axis are gathered into a single variable and then passed to the chart. I have tried using textual f…

I want to set up a chart to easily view via line chart the total monthly invoices for each month. With each new month, as new invoices are produced day by day, the line chart extends to show the new months total also. Not sure how i can group each months total invoices on the chart, and set a month/year 'x' category at the bottom. Then on the same layout i want a pie chart to display a break up of all customers, to gain a visual(%) of the total invoiced values, and their respective pie segments. Then under that pie chart, a 2nd pie chart to display ONLY the top 10(largest invoice values) customers as well. I am not sure what fields i need to chart the a…

Hello, I want to put field result as a label on the top of my bar in my chart (see attached files) does anyone now how??

Hey, I need some serious help on this one... I have records that have move in dates and move out dates, and I want to be able to see them charted on a schedule. Almost like a bar graph, but with the increments as days, and I can get a visual look at who is moving in soon, or moving out soon, based on the current day. Does anyone have any idea how to do this? I've search on the web but haven't found much that is what I'm looking for. Thanks.

Display top 4 Regional sales only via a bar chart Hello all I have managed to summarize my data like the following: Regional name: Total Sales: A $199,500.00 A $400,100.00 B $344,200.00 C $222,600.00 D $663,800.00 D $199,223.00 E $788,222.00 but I would like to display only the TOTALS of the top 4 regions (bars) via a bar chart. How would I limit the data the chart displays. I'm guessing that it will involved a calc field but not sure how. Thanks in advance.

Hello to all and thanks for any help. I'm a complete newbie to FM! I have DB I trying to make that has a table for PROJECTS, and a table for CLIENTS. I have a CLIENT field in the Projects layout. Using the Manage feature, I drew a line and created a relationship between "Name" in the CLIENTS DB to "CLIENT" in the Projects DB. Is there a simple way that when I type in the PROJECTS " CLIENT" field FM will see what I am typing and autocomplete this? I cannot seem to get this going. I have SMITH AGENCY in "CLIENTS" and when I type SMITH AGE and go to tab out, it does not auto complete as I thought it would. Thanks for any advice!

I have a simple database that contains my fountain pen inventory. I have found a calculation via this forum that tells me how many pens I have from each manufacturer (Sheaffer, Parker etc)which forms the vertical axis of my bar graph. The issue I have (simple to you guys, is that I have 33 Sheaffer pens. The correct total is shown on the vertical axis, but my horizontal axis shows 33 seperate bars for Sheaffer (working on current found set which I understand), but I only want one bar on the horizontal axis for each manufacturer. I'm not sure if a calculation will do this or if a related table would be better which has a single record for each manufacturer. Please go easy …

Hello I would like to display a layout with a bar chart within my runtime solution via a button if the user happens to have a full version of FMP11 or higher but prevents the user from going to the chart page if they do not have a full version of FMP11 or higher. Since you can't display charts within a runtime package. What command determines if the user is running a runtime version or not?

This is my first effort with native charting in filemaker so forgive my dumbosity. Is there a way to affix a label to pie chart to describe what a particular section of the pie chart represents? I have a database that counts items that my cabinetshop produces. For example: Cabinet A has 3 drawers and 1 door. Cabinet B has 2 doors. I am trying to get a pie chart to show me the relative importance of door quantity vs drawer quantity. The pie chart shows up fine but nobody can tell what each wedge of the pie represents, How do I associate labels with pie sections?

My goal here is to have a chart that shows a customers name, and then a move in and a move out date, on a schedule. The purpose is to be able to see who is moving in or moving out soon. Is this even possible?? I want it to look something like this:

Hello all. I am trying to chart lab values for patients that had the tests done on various dates that are not linear. The graphs show the dates on the x axis but one after the other and not spread out as they should appropriate ti the time between dates. ie: y x --------------------- 2.5 Jan 5, 1996 3.1 June 11, 1997 5.6 Feb. 13, 2001 6.3 Dec. 5, 2001 9.3 Aug 12, 2006 Any help all?

Hi i have a terrible charting and report problem i want to chart categories of a database base on a related set of records. The structure of the database is a table of financial assets each one belongs to a category. Every month I receive the fair value of the assets that are being managed by differents banks. Table One Asset; category; date of report; bank;value Table Two Date of report For ech "Date of report" record I want to visualize a pie chart by category for each bank of the related records of thar date of report I can´t get that kind of chart. please help regards CAM

Is there any way to chart multiple series on a line chart based on the current records? I would like to chart a known set of values, such as months of the year, along the X axis. Then have a series (sales) for each person on the Y axis based on the current found set where each record is a series on the chart. It seems like the Y axis must be defined when creating the chart. Can FMP11 do this or should I look at plugins? Thanks, Scott

Hello everyone, I have a question about charting that I've been researching for several weeks but haven't been able to answer. I'll start by summarizing what I /have/ gotten to work, and then will ask about where I'd like to take things: What /is/ working: I have a two tables in a database that tracks participants in research studys. The first table is called Study Summary, and it records all of the information about a particular research study. One of the fields in Study Summary is Eligibility Criteria, which is a multi-line field in which all of the criteria for study participants are listed. The second table is called Participants. Each record in the Participant…

I found if i format a chart by using a repeating field, the chart only ever seems to display the first repeating field value. Is there a way to chart the entire repeating field values?

I want to increase the line weight in a line chart. The standard looks to be about 1 pt and I'd like 3-4 pts. If it's possible, it isn't obvious. Anybody know how to increase the weight?

I have a simple pie chart which displays the number of projects assigned to each of five people. When everyone has at least one assignment, the pie chart is fine. But if one of them has no current assignment, their name does not appear in the label data. Of course, they would not appear in the pie chart itself since there is nothing to display, but I would like to at least see their name in the label data so that the higher-ups will see that they are available for assignment. Thank you, Kevin

I'm really drawing a blank here. I have fax logs that I need to analyze by the hour. So far I've set up two tables, Fax Report and Fax Item. Fax Report is the date that I want to create a report for and Fax Item represents each fax that has received. So far I've managed to create two charts, one that summarizes the average numer of fax pages received for each day and one that summaries the total fax pages received per day. These were pretty easy to do. I am running into serious trouble when it comes to creating a chart that summarizes the number of faxes received per hour for that particular day. I've pretty easily created the relationships that would allow…

[Projects] table [Dates] table I'm trying to generate a bar chart - based on the current set of projects - showing the number of projects per month. Should the chart layout be based on records from the Projects or Dates table? I'm also stumped on the calculations for the vertical and horizontal columns. Any help would be greatly appreciated — Thanks!

Hi, I have the following tables: Visits[VisitID,PatientID] Prescriptions [VisitID,DrugId,Amount] DrugDetail [DrugID,DrugName,Category] On the "Visits" layout I am trying to put a chart that on Axis X will show the drug Category, and on Axis Y the total amount for that category.. I've been trying for hours with all the possible combinations but all my efforts didn't help Any suggestion?

I have a list view set up with employee's direct/indirect (charged/not charged) hours, that is set up as: Sub Summary Sorted by the Week ending date. Each new week in the list then has listed underneath the employee's names, direct and indirect hours. When i change the Chart to Current Record (Delimited data), i can click on each individual employee, and the Graph will only show that employee's hours graphed. This is good. However, i am trying to also enable a graph populated by data from the entire week ending date(all employee's hours for that current week). But the Week Ending date is not able to be clicked to graph the data, as it is in the Sub Summary…

how can i have the ability to draw on a field. eg. i want to have a drawing of a human body and allow the user to draw on it where there are scars or abnormal features. thanks