$$Excel-Macros$$ Re: want to show always last date in date range in chart X-Axis

2012-08-13 Thread Prince Dubey
Hi Divaker, Can you plz share ur work book with group. regards prince On Thursday, 9 August 2012 19:17:50 UTC+5:30, Divaker Pandey wrote: > > Hi Expert, > > can any one help me to show last available date in chart -xaxis range. > > > Divaker > -- Join official facebook page of this forum @ h

$$Excel-Macros$$ Re: want to show always last date in date range in chart X-Axis

2012-08-13 Thread Kishan Reddy, K
One way is to display every value on x axis. But this will work only for limited values on x. Means your date range is below 20 or 30. Here you have to format the x axis. Select the scale tab. set the minor unit = 1 and major unit = 1. Another way is to display the max date above or some where