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
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