I cant remember how to do this??? Chart that allows you to c

[Kulata]

I saw this on the back of an excel book....and of course I cannot find the book right now

Lets say I have three columns of data, 1) Products, 2) L52 Wk Sales, 3) L12 Wk Sales

I would like to build a chart that is based off of the products column and one of the time period columns. But this is the kicker, I want to be able to choose which time period is displayed in the chart. And I want to format the spreadsheet so that a non-excel techie can easily do this.

For example, I create a sales report and send it to my boss. He should be able to chose his own time period without having to call and ask how.

I think I remember seeing somthing like a dropdown box and you choose from the box. But I cant remember the key words to look up in the excel books that I have.

Any help you can give me would be greatly appreciated!

Kulata

[ This Message was edited by: kulata on 2002-05-01 20:41 ]

[brettvba]

[brettvba]

[svmac]

What you are thinking of is a pivot chart.

Refer to the excel help files on this topic, they are quite helpful.

Good luck
Stuart