Problems with assigning range of cells to display chart

[Richard Flame]

Hi,

I'm working on a big Excel workbook and i'm having problem
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 th
month. Once the month is picked its data will be displayed. There's
Value X (Wholesale) that will be displayed after the selection of th
month. I want to represent the wholesale from different months in m
chart. I cannot assume that the wholesale is constant and copy the dat
somewhere else and create a chart. I want daily updates of the wholesal
throughout the month. So how do i do that? I would appreciate an
help..Thank yo

 

[Jon Peltier]

Perhaps you could adapt this example to your situation:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.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]...

 

[Richard Flame]

Thank you it will help

 

[Richard Flame]

Thank you it will help