pivot tables

[Priscilla]

I have a table that has in a column dates, then I have products and below
each product there is a price, according to the date. Now what I need to do
is to make a chart that allows the user to pick two products on a specific
date. I can do this If I change all to columns, but not in the row format.
Date Plastic wood
Dec 10 20
Nov 12 22
can you please advice?

Thank you so much.

Best regards, Priscilla

 

[Jon Peltier]

Priscilla -

You can rearrange the data to make an appropriate source range for a pivot table,
with columns for date, product, and value. This will allow you to make a pivot table
with the same layout as the table you describe.

An alternative is to use some worksheet controls (checkboxes) to allow the user to
select which columns to plot, as in this example:

http://peltiertech.com/Excel/Charts/ChartByControl.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______