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

Kulata

New Member
Joined
Apr 4, 2002
Messages
26
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
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
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
 
Upvote 0

Forum statistics

Threads
1,213,539
Messages
6,114,221
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top