i have deleted the chart and re ran the wizard and chose a different table.
then went into the data.php file within dynamic charts and added the recordset manually and it seems to have worked now doing that.
strange.
i now have a further issue eric, on the main site one of my graphs displays the companies who have had the most cases. this works on the main site. on the indivdual comanies sub domain site it shows nothing on the chart yet below in the table it shows the data no problem.
it is 2 seperate databases they are accessing and all the other graphs on theis sub domnain work except this one.
is there any common trouble shooting i could take to find why this has happened?
i have went in and checked the connections are ok in the connections folder and they are and all other charts are fine just this one page?? i opened up the recordset and clicked test and it is fine.
if there is more data on their chart will dynamic charts auto resize it to fit in to the graph all the data?
thanks again