Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
drop menu for charts
1. Create a summary table of BOH by reset date with total inventory (BOH) by
week with a count of stores on each date and totals at the bottom 2. Format data cells BLUE if Value is greater than 73,000. Use formatting to do this, don't hunt, find and color. 3. On a separate sheet, create a tool with a drop down box to select a given reset week and populate a small table with just the data for the selected week. 4. Graph the data for the selected week. I have 1 & 2 but not sure how to complete 3 & 4. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down choice needs to lead to another drop down menu | Excel Discussion (Misc queries) | |||
Putting Charts into some kind of Drop Down Menu | Charts and Charting in Excel | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions |