I am trying to implement a chart into my DataBase using data that I pulled from an excel.
I created a table for it gave the table the fields I would be importing from the excel. I then linked the added a relationship to the data so that it would be relative to the job I was working on. I created a quick portal to make sure the data was accessible via the relationship and it is. So next I dropped in a chart and set the x-axis to one field and the y-axis to the other.
At this point I am only getting one row one the chart which is the first record in the field referenced. Should the chart use all the records within that field linked to the job? Currently there are 180 records that have been linked I would have thought I would now have 180 rows on the chart.
I am sure that I am doing something minor but a little insight would be very helpful
Thanks in advance
Check the "data source" tab. choose "related records" and your "related table".
Posting a demo sandbox file would help us to diagnose the chart as well.