bar chart with year values with line chart with month values
Hallo
i am trying to built a graph with the month and year on the x axis.
the first data serie has only year values and should be drawn as a bar chart.
the second data serie has monthly values and should be drawn as a line chart.
both data series are stored in a postgresql database. my problem is, that i stored the first data serie for every year under '2001-01-01' for 2001.
What do i need to do, that the bar chart is going to be as wide as 12 month? is there a parameter for pchart or do i need to store the data in a different way?
i hope i made my problem understandable! If not have a look at the attached png. the bar charts should be as wide from the first of 2006 till the 12 of 2006.
alex
Attachment:
bar_and_line_chart.png [ 24.94 KiB | Viewed 4155 times ]