hoagieryder
MIS
I have a very simple graph that has two summarized fields balance and rate on change of date. The problem is that the dataset has data for rates on a daily basis and balance on a monthly basis:
Date Balance Rate
6/30/2010 4250 4.63
6/29/2010 0 4.54
6/28/2010 0 4.67
6/27/2010 0 4.56
6/26/2010 0 4.66
6/25/2010 0 4.57
6/24/2010 0 4.69
.
.
.
5/31/2010 4340 4.84
I have the graph set up as a Bar graph, and have the rates series as a line. I only want x-axis data labels when there is data in balances(monthly labels). Is there anyway I can do this so I do not have a data label for everyday, rather monthly?
Date Balance Rate
6/30/2010 4250 4.63
6/29/2010 0 4.54
6/28/2010 0 4.67
6/27/2010 0 4.56
6/26/2010 0 4.66
6/25/2010 0 4.57
6/24/2010 0 4.69
.
.
.
5/31/2010 4340 4.84
I have the graph set up as a Bar graph, and have the rates series as a line. I only want x-axis data labels when there is data in balances(monthly labels). Is there anyway I can do this so I do not have a data label for everyday, rather monthly?