XY scattergraphs with autofilter

  • Thread starter Thread starter Jim P
  • Start date Start date
J

Jim P

I would like to view plots of data that have been filtered
using the Autofilter dialog box, but have experienced
inconsistent results. If I turn the Data/filter/autofilter
on, then create a graph, the imbedded graph scrunches when
I perform a simple filter (eg search for one of the column
values), but the visible data are plotted OK. However,
when I perform a custom filter (eg. "equal to or less than"
a fixed value) the graph lines disappear altogether even
though I can see many data meeting the filter criteria in
the table. What are the rules here? Does the graph have to
be created before Autofilter is turned on? Any insight will
be appreciated.
 
Jim -

To prevent the first problem, select a cell, then hold shift while
selecting the chart. Choose Object from the Format menu, click on the
Properties tab, and choose the second or third option (move but don't
size with cells, or don't move or size with cells).

I couldn't reproduce your second problem, unless I misunderstood your
description. Any custom filter worked like a simple filter.

- Jon
 
John -
Thanks. Formatting the chart object to "Move but don't
size" with cells fixed the first problem. And
mysteriously seems to have also cleared up the second.
This certainly isn't the first time I've been baffled by
software. I spent hours over the weekend tinkering to get
the chart to work consistently with a custom autofilter.
Now I can't reproduce the problem either! Thanks again.
Jim P
 
Back
Top