You need to use an area chart series. It gets complicated to get the
vertical edge at the last selected point. However, I just remembered another
page on my web site:

http://peltiertech.com/Excel/Charts/XYAreaChart.html

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



"unique" <unique@discussions.microsoft.com> wrote in message
news:E0BE9973-8712-42E6-A850-0DBEB780C667@microsoft.com...
>
>
> "Jon Peltier" wrote:
>
>> The example near the bottom of this page:
>>
>> http://pubs.logicalexpressions.com/P...cle.asp?ID=246
>>
>> shows how to use a slider to control which data is charted. Ignore that
>> my
>> example uses dates, and just set it up for whatever units your X-axis
>> uses.
>>
>> - Jon
>> -------
>> Jon Peltier, Microsoft Excel MVP
>> Peltier Technical Services
>> Tutorials and Custom Solutions
>> http://PeltierTech.com/
>> _______
>>
>
>
>
>
> Hello,
>
> yes I understand whats on that sheet, but I still cant get it what I want
> it
> to do. How do I make it so the colour under those lines, gets filled, from
> clear as you press the slider.
>
> regards
>