Hi All,
I have a data series where the X-values (dates) are neither continuous nor in equal gap or interval. How can I show only the dates on X-axis for which I have a Y-value?
Attached file will clear the problem. In the file, the graph shows all the X-values (dates) at equal interval. I want only the dates to be seen for which there is a price point or Y-value, like 1-Jul then 5th Jul, 18th July and so on.
Can it be done in Excel 2007?
Awaiting your replies.
--Warm Regards,
Bookmarks