Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
chart from drop down list of ranges
Hello,
I am new to this site, and a fumbling learner of Excel, so I am grateful for any help. I am trying to make a chart by selecting a region from the drop down. I hope that it will populate a chart with the data from the region, as well as be self adjusting in the axes of the chart based on the size of the region, but I'm not educated enough to get to that point. Any words of advice will be welcome. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
chart from drop down list of ranges
I would suggest you start by downloading Stephen Bullen's FunChrt1.xls from
http://www.oaltd.co.uk/MVP/Default.htm Shows how to define names for dynamic ranges that chart only what is available. With that workbook, select B5 which is "Results" Autofilter on that column for "Top 10" and see how the chart changes to show only the visible data. Your worksheet could be setup similarly so you Autofilter by the region to be charted. Gord Dibben MS Excel MVP On Wed, 30 Jan 2008 08:39:01 -0800, LDP Analyst wrote: Hello, I am new to this site, and a fumbling learner of Excel, so I am grateful for any help. I am trying to make a chart by selecting a region from the drop down. I hope that it will populate a chart with the data from the region, as well as be self adjusting in the axes of the chart based on the size of the region, but I'm not educated enough to get to that point. Any words of advice will be welcome. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
Named Ranges don't show up in drop-down list | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Drop Down List for Chart | Excel Discussion (Misc queries) | |||
Creating drop down list for multiple cell ranges | Excel Discussion (Misc queries) |