Hello Everyone, I have no professional training in SharePoint, all learned on my own, and I am having a challenge I cannot currently overcome, although I did once however cannot remember how. I have a SharePoint List WebPart filtered by current user info returing monthly performance figures as compared to standard and now trying to add team average. From these 2 List WebParts (that pull from different views of the same SharePoint list) three Dundas Charts (1 column and 2 step line) are created from connecting to these webparts. Almost all columns except for name and month have numerical values. When I go through the wizard to connect to another WebPart the columns I need do not appear in the drop down for y-value. I feel like I remember doing something to define the series of data to be featured in these drop down and coming up with unique names but for the life of me I cannot remember. The SharePoint List follows the pattern below (columns sperated by a "/"): KPI=Key Performance Indicator ID Number / Agent Name / Month / KPI 1 / KPI 1 Target / KPI 1 Avg / KPI 2 / KPI 2 Target / KPI 2 Avg / KPI 3 / KPI 3 Target / KPI 3 Avg So each agent has 12 lines with the List so that Performance, Targets, and Averages can be reported and changed for each month with data clustered into columns or step lines by month as well. I hope someone can assist. Thanks, Anthony

Hi AnthonvRobinson, You may use the dundas support to find the solution. http://support2.dundas.com/Default.aspx?article=946 Thanks,Lambda Zhao TechNet Community Support

Interesting one this one. You appear to be using fairly old technology. Ive had a look at thier user forums which may also be a way forwards for you; - http://support2.dundas.com/forum/ The notice on the forums advises that the Dundas components were acquired by Microsoft. I dont know the Dundas software but there might be another way to achieve what youre after within SharePoint. What version of the product are you using?Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/

SharePoint Server 2007 with Dundas Chart for SharePoint. I have scoured the dundas support site, however, there doesnt seem to be an answer present there. I was trying to see if the KPI webparts would do anything but nothing that showcased a chart, or at least that I saw. I'll go back and check into it again though.