How to update a chart from filtered results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 -
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
 
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
 
Back
Top