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
Hi
Can you please attach an example file for review.
rylo
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.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks