Filter Dates in Charts

[aaronnechama]

I want to plot data over a series of dates, but wish to exclude weekend data. I add a column to the series called "day", use the WEEKDAY function to determine the day of the week, and use a filter to select only workdays. However, the chart still plots data for all the dates, and ignores the filter. How do I get the chart to only display the dates that are visible, and to ignore the dates that are filtered?