Another thing which could be done is to copy the Axis row to another section
outside the autofilter area and then reference this row.

"Birmangirl" wrote:

...I have a large amount of amount to produce multiple charts from, so using
Autofilter is a bit of a necessity. Using the Chart Wizard, I can easily
select the filtered data range but it doesn't seem possible to select the
(filtered) headings as the X-axis (time period). Any ideas or workrounds?

Thanks in advance,
Amanda