How can I make my Chart Web Part look good when I use it with lookup fields?
The issue I have is that the chart displays the field id along with its value. For example, it displays "2;#Bing" when I'd like to see only "Bing".
you can use xpath to do that, for example /dsQueryResponse/Rows/Row[substring-after(@field., '#')
But that has to be done in a dataview that displays a content source in your page
I have mention how to split values in your chart web part,
Hope this answers is very helpful for you.