Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > Reporting Services
|
Reporting Services SQL Server Reporting Services. Please specify which version.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Reporting Services section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 6th, 2007, 06:05 PM
Registered User
 
Join Date: May 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Coloring 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


 
Old October 25th, 2007, 02:50 PM
Registered User
 
Join Date: Oct 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi There !
           You can divide the background of the chart by using gradient.However its only restricted to 2 colors ( what i assume ). You can add the 3rd color too but then the 3 colors will blend into one another as one color transits to another.

Here's the code that might solve your problem.


     <mx:fill>

   <mx:LinearGradient angle="270">
    <mx:entries>
     <mx:GradientEntry color="#005500" ratio="0.5" alpha="0.9" />
     <mx:GradientEntry color="#ffff00" ratio="0" alpha="1.0"/>

     <mx:GradientEntry color="#ff0000" ratio="0.9" alpha="0.9"/>
     </mx:entries>
   </mx:LinearGradient>
    </mx:fill>


take care ..
dino.






Similar Threads
Thread Thread Starter Forum Replies Last Post
plot bar chart in a web page pratik28 .NET Framework 2.0 1 April 23rd, 2007 03:54 AM
non-linear y-axis scale for stock charts Alseikhan Excel VBA 0 March 28th, 2006 01:54 PM
Aligning two chart plot areas - simple but tricky! Alseikhan Excel VBA 0 March 20th, 2006 07:18 PM
How to plot data from an array in a line chart ! Alseikhan Excel VBA 0 January 27th, 2006 12:22 PM
Excel VBA: Select range of data and plot chart? xitu Excel VBA 1 December 23rd, 2003 04:21 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.