Hi Gurus,
can you please help me how to plot dates which are unequal in interval
the dates that I want to plot are the following:
1/2/13
1/7/13
1/14/13
1/21/13
1/28/13
2/4/13
2/11/13
2/19/13
2/25/13
3/4/13
3/11/13
3/18/13
3/25/13
I want to appear them exactly on my X axis no different dates in between them. Is that possible?
Thank you so much in advance.
Thong
It is not entirely clear to me what you want. If you want it to treat the x axis as a true category/text axis and not a date axis, right click on the x axis -> format axis -> select text axis option.
http://office.microsoft.com/en-us/ex...in=HP010007448
Originally Posted by shg
Hi MrShorty,
Thank you so much. and sorry for not making myself clear. what i want is I want the dates (1/2/13,1/7/13........3/25/13) appear as they are written on my table. I tried to plot but excel gave me an interval of (1/2/13, 1/7/13, 1/12/13...3/23/13)
Thong
Hello All.
No worries, I got it.
Thong
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks