Using Filtered values as values for a chart

[TheNef]

Hello,
I have an excel sheet that contains filters and what I want to b
able to do is create a chart using only the values that are visible a
applies to the filter . At the moment I have the macro working t
create the chart but have had to hardcode the start and end range int
the macro. The ranges will be sequential but would appreciate knowin
if this could be done wether the range was sequential or not.

Thanks in advance for any hel

 

[Tom Ogilvy]

Create it using all the range.

with the chart selected, in tools =>Options => Chart tab, make sure visible
cells only is selected.

Set this with the macro recorder turned on to see the code to set it.