• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1194
  • Last Modified:

SQL Report Builder Chart Formatting

Hi all,

These two questions are KILLING me!

With regard to a chart object in Report Builder 3.0:

1. How do I move elements freely - without that area-style snapping. Ultimately I simply want less white space between the chart title, legend and chart.

2. On a bar chart (horizontal), can I display the same horizontal value axis on the top of the chart as well as the bottom. I have a page long list of categories so displaying the value axis on top and bottom would make for easier reading.

I have been working on this for a while and I am stuck.

Thanks in advance.
  • 2
1 Solution
Nico BontenbalCommented:
2. Maybe you can use this: http://technet.microsoft.com/en-us/library/dd207018.aspx. Add a secondary value to your chart that's all zero's and 'plot' those on the secondary axis.
PharmAllAuthor Commented:
1. I enabled "custom position" on the object properties and used values (not the mouse) to move it.

2. It doesn't look possible...?
Nico BontenbalCommented:
I think it is. Please see the attached report. You need to change the Data Source of the report in order to run it, but you can see the double axis in the Design mode as well.
The dummy values series uses the secondary axis. I've set the min and max values of the axis so they are aligned.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now