Colouring the chart plot area based on x-axis scale

Hi,

I have a report based on a line chart.

The values on X-axis are scaled from -100 to +100. I want to colour the band from -100 to 0 with red colour and that from 0 to +100 in green colour, and i want to provide legend for these bands/sections. How can i do this?

This doesn't look like a tough thing to do but i can't find a way to do it within the chart properties.

Basically i would like to divide the chart (plot area) into multiple vertical bars, each having a different colour. The colour is determined by the range that vertical bar covers on the x-axis

Thanks a lot!

Simranjeev

To color the bars on the chart, go to Chart Properties -> Data -> Edit button in the Values section -> Appearance Tab -> click the Series Style button -> Fill tab

You will have to enter an expression in the color property for the bar to be one solid color. The expression should look something like:
IIF(Fields!XAxisField.Value < 0, "Red", "Green")

You can do this if the axis value is a number or date. You may have to nest a couple of IIF statements if there are a lot of sections that you want to use. I don't think you can use the legend provided by reporting services for what you want it to accomplish since it is based on the series fields. You can create your own legend with a few lines, textboxes, and property changes though.

Colouring the chart plot area based on x-axis scale

Hi,

I have a report based on a line chart.

The values on X-axis are scaled from -100 to +100. I want to colour the band from -100 to 0 with red colour and that from 0 to +100 in green colour, and i want to provide legend for these bands/sections. How can i do this?

A prompt response would be really appreciated

Thanks a lot!!

Simranjeev

Hi!

This is a little urgent so i would really appreciate some response.

This doesn't look like a tough thing to do but i can't find a way to do it within the chart properties.

Basically i would like to divide the chart (plot area) into multiple vertical bars, each having a different colour. The colour is determined by the range that vertical bar covers on the x-axis

Thanks!

Simranjeev

Colors for Line Chart

Hi,
I have created a line chart with 3 different datafields. I want them to
have the colors yellow for the first, red for the second and blue for the
third. Is there anyway we can manipulate the colors on the chart? If there
is, can you kindly tell me how or point me in the direction of how to do
that?
Thank You,
RickyYou will need to have SP1 of RS 2000 installed on the server and designer
machines. In particular, read the following section of the SP1 readme file
about using colors in charts:
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_chart_enhancements
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ricky" <kmeas1@.gmail.com> wrote in message
news:Oj5gfVHPFHA.3380@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I have created a line chart with 3 different datafields. I want them to
> have the colors yellow for the first, red for the second and blue for the
> third. Is there anyway we can manipulate the colors on the chart? If
> there is, can you kindly tell me how or point me in the direction of how
> to do that?
> Thank You,
> Ricky
>

colors

Hello is there any way in a text box to make the text different colors?
For example,
if you have "Hello World"
I'd like "Hello" to be red and "World" to be green.
Thanks,No, the format applies to the whole control.
HTH, Jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--