Hi,
I am trying to draw line chart having the X-Axis with date ( month and year ) and Y-Axis with Price.
I will have the Price for almost all the days ( except holidays ) which I need to show the values. But, in the X-Axis (Date) I just need to show the values on monthly basis like, Jan 13, Fed 13, etc..
The values on Y-axis (Price) shouldn't have any aggregate functions applied to it. It should show all the values. How can I achieve this functionality ?
Ex. of my data from :
Date Price
01/10/2013 12.3
01/11/2013 13.3
01/13/2013 10.3
.
.
.
02/09/2013 16.3
02/10/2013 19.3
.
.
03/01/2013 12.3
.
.
I would like the chart like,
Y-Axis
12.3, 13.3, ...16.3,19.3,....12.3
X-Axis
Jan 13
Feb 13
Mar 13
Thanks!
Karthik