|
Should be pretty simple with PivotCharts ...
Column A = Item Name
Column B = Price
Column C = Date
Highlight A1 to C? (end of table), select Format as Table (colour scheme doesn't matter, just choose whatever looks best to you).
Once you've formatted it as a table, Insert > PivotTable > PivotChart
On the right, put Item in Legends Fields, Date in Axis Fields, and Price in Values.
Right-Click on any empty space in the Chart, then select Change Chart Type, select a line graph.
On the right side of the chart, you'll see a grey box with Item and a down arrow next to it. If you click on that, you can select which items you would like to have displayed ...
See attachments for visuals ...
Last edited by Jmac; 08-02-2011 at 04:46 PM.
|