Skip to Content
0
Former Member
Sep 14, 2007 at 09:28 PM

12 Month Chart

81 Views

Post Author: elektrobank

CA Forum: Charts and Graphs

I want to create a 12 month chart of sales data. This part is easy enough, but the trouble I'm having is that it only shows bars for the months that there are sales. I want it to have a label for every month of the year across the bottom of the graph regardless of whether there is going to be a bar for it. The only way I can think to do this now is to create a 3rd table that contains number from 1-12, then do a left join on the month part of the date in the sales table. This is annoying though and requires additional programming outside of CR. I imagine that this would be a pretty common graph but I can't find one single write up on how to do it. Any idea?