Assuming your data has headers of Date, Company Name, and P/L:

Select your data, go to Data, PivotTable. Select a PivotChart, then hit
'Finish'.

Place Date into the Category Field area. Place Company Name into the series
field area. Place P/L into the Data Items area.

Finally, right-click on chart, change type to line. You can now use the
series filter to choose which companies you want to look at.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Trevor Greene" wrote:

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!