Report designer-graphing tool

I am trying to have a horizontal bar graph which has a single bar, which
has spacing top and bottom but none left and right of the bar, however the
"side margings" doesnt seem to work, has anyone got any ideas how to do
this also I need the single bar to be as tall as the grid almost, so I need
to resize the bar manually.
Any ideas greatly received.
TIA
AndyChecking the Side Margins property should do exactly what you want. Also
check your Min and Max value property - these affect how your bar is drawn.
If you leave them empty, your chart should autoscale.
If that does not help, please post a picture of your chart, so that we can
see what you are trying to do.
--
Carsten Schielke
Software Development Engineer
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andy Bontoft-Robinson" <andy@.streets-heaver.com> wrote in message
news:Xns95406167DB603andystreetsheavercom@.207.46.248.16...
> I am trying to have a horizontal bar graph which has a single bar, which
> has spacing top and bottom but none left and right of the bar, however the
> "side margings" doesnt seem to work, has anyone got any ideas how to do
> this also I need the single bar to be as tall as the grid almost, so I
need
> to resize the bar manually.
> Any ideas greatly received.
> TIA
> Andysql

report colours

Hi

I have a report with 2 charts on it (a pie chart and a graph). The series are set out as :

pie chart

series 1 -total 1 - red

series 2 - total 2 - blue

series 3 - total 3 - yellow

series 4 - total 4 - green

graph (stacked)

series 1 -total 1 - green

series 2 - total 2 - red

series 3 - total 3 - blue

series 4 - total 4 - yellow

as the 2 charts refer to the same info, i would like the colours of both sets of series to be identical - how can i do this?

The colors for each of the series should be identical in each of the charts, as long as the charts are set up the same way, with the values, series, and categories in the same order. Since a Pie chart can only have display one series, there is some behind the scenes magic that takes place to convert a chart with multiple series into one series. This may cause issues with having the colors be identical.

If this is the case, adjusting the order of the various added fields may resolve the issue. If this does not help, then you may need to write some custom code that looks up the correct color based on information during report processing.

I would first take a look at the order of values, series, and categories, and if adjusting the order does resolve the issue, I can help you create some custom code to get the correct color for the series.

Ian|||

thanks for the reply Ian. I got around the problem in the end by adding an additional column to the database which contains the colour references. I then use this column in the chart properties appearance. Not the best way to fix the problem, I admit - however, as the table is a reference table which is not likely to alter for some time (if at all) - it works...

report colours

Hi

I have a report with 2 charts on it (a pie chart and a graph). The series are set out as :

pie chart

series 1 -total 1 - red

series 2 - total 2 - blue

series 3 - total 3 - yellow

series 4 - total 4 - green

graph (stacked)

series 1 -total 1 - green

series 2 - total 2 - red

series 3 - total 3 - blue

series 4 - total 4 - yellow

as the 2 charts refer to the same info, i would like the colours of both sets of series to be identical - how can i do this?

The colors for each of the series should be identical in each of the charts, as long as the charts are set up the same way, with the values, series, and categories in the same order. Since a Pie chart can only have display one series, there is some behind the scenes magic that takes place to convert a chart with multiple series into one series. This may cause issues with having the colors be identical.

If this is the case, adjusting the order of the various added fields may resolve the issue. If this does not help, then you may need to write some custom code that looks up the correct color based on information during report processing.

I would first take a look at the order of values, series, and categories, and if adjusting the order does resolve the issue, I can help you create some custom code to get the correct color for the series.

Ian|||

thanks for the reply Ian. I got around the problem in the end by adding an additional column to the database which contains the colour references. I then use this column in the chart properties appearance. Not the best way to fix the problem, I admit - however, as the table is a reference table which is not likely to alter for some time (if at all) - it works...