I am trying to change the X-axis date range to Feb 1/14 - Mar 20/14.
I have data from Jan 1/14 - Mar 24/14. How can I do this in VBA or Excel 2010.
I am trying to change the X-axis date range to Feb 1/14 - Mar 20/14.
I have data from Jan 1/14 - Mar 24/14. How can I do this in VBA or Excel 2010.
Last edited by Xx7; 03-19-2014 at 07:09 PM.
In your Pivot Graph, there is a Date filter in the lower left corner. Click on that and click on Date Filters. Click on Between and use the calendars provided to select the first and last dates. Your chart will update to show only that data.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Perfect, thanks alot newdoverman!
I've included a button to update this.
Please Login or Register to view this content.
Thanks for the feedback. The addition of a button seems like a good idea to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks