View Single Post
Old 08-02-2011, 04:33 PM   #2
Jmac
Willing to sell body for a few minutes on RS
 
Jmac's Avatar
 
Join Date: Aug 2004
Location: Duncan, BC
Posts: 10,128
Thanked 5,568 Times in 2,107 Posts
Failed 231 Times in 90 Posts
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 ...
Attached Images
File Type: jpg Excel1.JPG (37.7 KB, 0 views)
File Type: jpg Excel2.JPG (106.4 KB, 0 views)

Last edited by Jmac; 08-02-2011 at 04:46 PM.
Jmac is offline   Reply With Quote