Skip to Content
0
Former Member
Dec 09, 2013 at 07:49 PM

Line Chart with X - Month and Year. Y - Price for all days

29 Views

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