Thursday, March 22, 2012

Bar chart problems

1. How can I move the left-most and right-most bar into the center so that it won't show only half?

2. How can I show the x-axis with all the day in a selected month? The dataset may contains only some dates but I would like the x-axis should all days.

#1:
On the x-axis tab of the chart properties dialog, select the "margins" option.

#2:
Make sure your category grouping expression returns a DateTime object. In addition, you must have the x-axis option selected for "numeric or timescale values".

Still, if the underlying dataset only has data for the 2nd till 10th of the month, you won't get the full month shown, unless you explicitly set the x-axis maximum value to the last day of the month. In RS 2005, you can use expressions for the x-axis maximum and dynamically calculate the last day of a month.

-- Robert

No comments:

Post a Comment