Hello,

I have some data based on companies.

The data is the following.... Each day, (using date), I have a new
Profit/Loss number based on a stock.

I have a list of companies about 100 long, and so far 6 dates worth of
P&L's. I am trying to set up a pivot chart to automatically create
line graphs for each company which I will filter, to see the trend in
P&L's. The problem is I am unable to draw the lines so the X
variables are displayed as dates, the Y as the Value of P&L, and have
it individually make a simple line graph for each company.

Any suggestions? I really don't want to have to write a line graph
each time for each company 100+ times, A filter would be 1000x
easier.

Thanks!