Anyone who follows my blog or knows me professionally knows that I love working with the Data View Web Part (DVWP) in SharePoint. It’s the Swiss Army knife of Web Parts, it’s a dessert topping, it’s a floor wax. Yes, it even can help you graph your data.
I’ve posted before about this technique for showing simple bar graphs using DVWPs, but I’ve just added a new demo page to our Sympraxis Consulting demo site based on a suggestion from Mauro Cardarelli.
Think about how a simple graph like this can enhance a dashboard for a project or a topic area by graphing things like discussion posts by topic, tasks by days overdue, or, as in the demo, a sales pipeline.
Using a simple DVWP, we can graph list data in slick ways. By clicking one of the buttons, a new sort column is passed back to the page on the Query String and the graph changes to reflect the selected column.
This demo shows data from a single list, but using an AggregateDataSource, you can also graph data from multiple, related lists.