How to update a chart from filtered results

P

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. 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?
 
J

Jon Peltier

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.
Click to expand...

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.
Click to expand...

I don't understand what you're saying,

- Jon
 
P

Panos

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.
 
J

Jon Peltier

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

- Jon
 
Top