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. |
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. |
All times are GMT +1. The time now is 03:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com