Panos -

I am trying to create a chart from a table on which i am using autofilter.
The main idea is for the chart to be automaticaly updated when the
selection
on the autofilter is made.

By default, an Excel chart only displays data from visible cells.
Autofiltering hides some cells, which are then hidden from the chart. If you
are seeing all data, including hidden data, select the chart, go to Tools
menu Options Chart tab, and check Plot Visible Cells Only.

Also, due to the fact that there are a lot of
series, i can't select the series name from the Series name button on the
chart options window.

I don't understand what you're saying,

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