Hi,

I have a spreadsheet that contains the following fields about sales
opportunities (plus lots of others omitted for clarity):

Sales Status Operating Group Revenue/K

0A X $50,000

0A X $10,000

0B Y $5,000

0B X $4,000


A colleague who has left my company created a tool in VB .Net that takes
data from this spreadsheet and creates several pivot tables based on it.

I have been asked to create a pivot chart in VB .Net that will show the
total revenue of all sales opportunities at a given sales status(i.e. total
revenue of all opportunities with sales stage of OA). Total revenue will be
on the y axis, sales stage on the x.

I have minimal experience with VB .Net, and would be really grateful if
anyone could tell me how I could do this?

Many thanks,

RJ