You could use an Advance Filter, instead of an AutoFilter. There are
instructions he

http://www.contextures.com/xladvfilter01.html

Or, creating another row of headings, directly above the filter
headings. When you want to print the chart, hide the row with the filter
headings.


HT wrote:
I created a chart that has a column of dates. Every week I send out the
chart and filter the column to just show one date. The drop-down button
appears next to all of the columns. I just want the results without the ugly
drop-down button.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html