Change the look of a chart
I have a report with a chart what looks like that.
Is there a possibility to change the look of the graph. The values ??should be in circles and the line to number 10 and 11 is to long.
Many thanks!
October 30th, 2011 4:05pm
Hi Sue4M,
Currently, there is no build-in feature to support circle border for series labels. One possible workaround here is making use
of Series Markers and locate the lablels in the center of the markers:
1.
Right-Click the series on chart, select Series Properties.
2.
In the Series Properties pane, navigate to Markers tab and choose Circle in the Marker type: drop down list. Change the Marker size to a proper size to contain
label value.
3.
Navigate to Border tab, reset the Line width.
4.
Click the label value, in the Chart Series Labels properties pane, set Position property to
Center.
For the long line between number 10 and number 11, you can sort X-axis labels in ascending or descending to have number 10 and
11 side by side:
1.
Right-click a field in the Category Field drop-zone and click
Category GroupProperties.
2.
In the
Category Group Properties dialog box, click Sorting.
3.
For each sort expression, follow these steps:
a.
Click
Add.
b.
Select the expression that matches your
value field(sum(Fields!<name>.value)).
You can verify the expression for the field by clicking Grouping.
c.
From the
Order column drop-down list, choose the sort direction for each expression.
A-Z sorts the expression in ascending alphabetical order.
Z-A sorts the expression in descending alphabetical order.
4.
Click OK.
Or, Specify an Axis Interval to reduce the space between values:
http://msdn.microsoft.com/en-us/library/dd239317(v=SQL.100).aspx
Thanks,
Lola
Please remember to mark the replies as answers if they help.
Free Windows Admin Tool Kit Click here and download it now
October 31st, 2011 10:25pm