Hello:

I used this nifty tutorial to build a dynamic chart: http://pubs.logicalexpressions.com/P...cle.asp?ID=246

Everything is great except for one thing: My x-axis, which pulls from column A of my data sheet, consists of dates, each a week apart. I.e. 1/7/2012, 1/14/2012, and so forth.

However when I set the dynamic chart for a smaller date range, the x-axis on the chart will populate with labels one day apart. For example 1/7/2012, 1/8/2012, 1/9/2012, and so on. I do not want those extra dates, How do I get it to to populate the dynamic chart with x-axis labels with just the actual dates from my data sheet, and not those extras?

Thanks