Problems with assigning range of cells to display chart

Hi,

I'm working on a big Excel workbook and i'm having problems representing my data in a chart and this is where the problem is:

I have a scrollable menu in my sheet that allows me to pick the month. Once the month is picked its data will be displayed. There's a Value X (Wholesale) that will be displayed after the selection of the month. I want to represent the wholesale from different months in my chart. I cannot assume that the wholesale is constant and copy the data somewhere else and create a chart. I want daily updates of the wholesale throughout the month. So how do i do that? I would appreciate any help..Thank you

Perhaps you could adapt this example to your situation:

http://pubs.logicalexpressions.com/P...cle.asp?ID=246

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Richard Flame" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi,
>
> I'm working on a big Excel workbook and i'm having problems
> representing my data in a chart and this is where the problem is:
>
> I have a _scrollable_menu_ in my sheet that allows me to pick the
> month. Once the month is picked its data will be displayed. There's a
> Value X (Wholesale) that will be displayed after the selection of the
> month. I want to represent the wholesale from different months in my
> chart. I cannot assume that the wholesale is constant and copy the data
> somewhere else and create a chart. I want daily updates of the wholesale
> throughout the month. So how do i do that? I would appreciate any
> help..Thank you
>
>
> --
> Richard Flame
> ------------------------------------------------------------------------
> Richard Flame's Profile:
> http://www.excelforum.com/member.php...o&userid=35944
> View this thread: http://www.excelforum.com/showthread...hreadid=557331
>

Thank you it will help

Thank you it will help