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. 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. Can anyone help me?
--
Panos

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
_______

You helped me but not like you would expect. I did something very stupid. I
first applied the fiter on my data and then created the chart. Afterwords i
expected my chart to update every time i changed my filter criteria, which of
cource didn't happen.
Solved it by selecting all data for my chart and applying the filter AFTER.
Nevermind the second leg of my question. Solved that too.

Thanks.

If I made you think, that's even better than saying 'click button A on menu
B'.

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


"Panos" wrote in message
...
You helped me but not like you would expect. I did something very stupid.
I
first applied the fiter on my data and then created the chart. Afterwords
i
expected my chart to update every time i changed my filter criteria, which
of
cource didn't happen.
Solved it by selecting all data for my chart and applying the filter
AFTER.
Nevermind the second leg of my question. Solved that too.

Thanks.