Dynamic Charts and Changing Dates

[dholzman87]

I have created a dynamic chart that has dates on the x axis. I am able to chart my data based on the dynamic range, however, my chart thinks there are more dates than there are.

For instance: Cells C5:I5 contain the following dates: December 2005, December 2006, December 2007, December 2008, December 2009, December 2010, October 2011

On my chart instead of having the 7 periods, it brings up periods for every month between December 2005 and October 2011...I am using named ranges with Offset and Match to pick my date range for the x axis. Here is the formula for the x-axis labels for reference:

=OFFSET(AllDates,0,MATCH(FY,AllDates,0)-1,1,MATCH(VDate,AllDates,0)- MATCH(FY,AllDates,0)+1)

AllDates is the range of all possible dates
FY is the Start Date (in my above example it is December 2005)
VDate is the End Date (in my above example it is October 2011)

Any help on this would be greatly appreciated.

David

[rylo]

Hi

Can you please attach an example file for review.

rylo

[Palmetto]

Select the X-axis and right click then select Format Axis. Under Axis type in the dialog, choose Text Axis. This will prevent Excel from inserting interpolated date values into the axis.