.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Chart bar with 3 colors ... red, yellow, green ... How?

Posted By:      Posted Date: September 09, 2010    Points: 0   Category :Sql Server
Chart bar with 3 colors ... red, yellow, green In Excel 2010 you know we have the Conditional Formatting->Color Scales and then the first ones are red yellow and green. Well I would like my Bar chart to do the same. That is … I have the Bar chart … say in % … so the maximum would be 100% … say we divided this 100% in 3 parts, 3 colors, so that the red and yellow fading out borde will be around 33% and the yellow and green zone will be around 66%. Now … if my data says that one bar is only 25% … well the three colors shouldn’t be in that little bar … I would like to only red … as the border of 33% has not yet been reached. It’s hard to explain … but really the colors should be fixed by the maximum 100% and not by how long the bar will be and then try to fit in the colors in there. How do I do this? Kind Regardsjea

View Complete Post

More Related Resource Links

Create Colors for columns in Chart , WPF

Hi, How can i dynamically create colors , which i want to asigned to the Columns in a WPF toolkit Chart control. i want the colors, which are suitable to the chart control (like the ones which are by default generated). thanks Naresh

Chart Tutorial

The AxisTitle class declares properties that define the common appearance settings of a title which is displayed by a particular axis.

Properties exposed via the AxisTitle class allow you to customize common title attributes, such as:

* the axis title's text (Title.Text),
* the color and font settings of the title's text (TitleBase.TextColor and TitleBase.Font),
* apply antialising (smoothing) to the title's text (TitleBase.Antialiasing),
* the alignment of the axis title (Alignment),
* the visibility of the axis title (TitleBase.Visible).


crystal report -visual studio 2008 dual axis chart (bar & line)


dear all, 

i use crystal report integrated with  vs.2008, and i want to make chart with dual axis (bar & line).

i have used bar chart and input the data with 2 values..

then in chart options > template, i activated the dual axis..

my question is, how i can change the 2nd value with line chart not bar chart??

i'd tried to find the right settings in "chart options" but still can't find the solution.

for information in "chart options" there are 4 sub menu : template, general,titles,grid..

i read in a tutorial there's more sub menu called "series" in crystal report (stand alone version)..

is it possible doing it in Crystal Report VS. 2008?

please,, i need your advice and solution..

Thanx before..


Toolbox: Microsoft Chart Controls, Visual Studio Automatic Code Snippets, And More


In this installment we look at the Microsoft Chart Controls; Snippet Designer, a free, add-in for Visual Studio 2008 for creating and editing Code Snippets; refactoring SQL applications; and this month's favorite blog.

Scott Mitchell

MSDN Magazine April 2009

Talking To.: Robert Green Talks About Communities for Visual Basic .NET


MSDN Magazine recently talked to Robert Green, the Community Lead Program Manager for Visual Basic, about what to expect in the next version and how the Visual Basic team hopes to work more closely with the Visual Basic community.

MSDN Magazine April 2004

How to merge 3 separated color (Red, Green and Blue) saved as grayscale images images into colored i


Hi friends, I have separated Red, Green and Blue color from a bitmap image and stored it in grayscale (obviously).  Now I want to know how can I merge it so that I can get the exact previous colour, when I am merging them by reading its color values but it is giving  me grayscale image :( . Please help me out with some working sample code. Thanking in anticipation.

I am using the following code:

 public bool mergeToRGBandWriteBitmap(string sourceRFile, string sourceGFile, string sourceBFile, string targetFile)
            bool isSuccessfullywritten = false;
                Bitmap bitmapRed = (Bitmap)Image.FromFile(sourceRFile);
                Bitmap bitmapGreen = (Bitmap)Image.FromFile(sourceGFile);
                Bitmap bitmapBlue = (Bitmap)Image.FromFile(sourceBFile);
   Bitmap afterMerge = mergeRGB(bitmapRed, bitmapGreen

Chart X axis is in Time



My application work in this ways. I got a database collect data from 20 sensors. Database holds Temperature and DateTime data/Records from sensors. So i would like to make it whenever i view the chart, it will plot a line chart one by one according to the temperature and timestamp(DateTime). Which mean my X axis is a colleborate time on that particular date. Anyone did this before or advice ? Thanks.

I already design a in the way that the line chart will plot base on both dropdownlist, Sensor ID and Date. So it will work like whenever i select a Date or ID it will read the records from database table temperature.

How to create a custom Gantt Chart for SharePoint using VS

So I have been told you can't create a custom gantt chart using SharePoint Designer.  I don't believe that actually, there must be a way to create one from scratch using SPD and a Data View and editing the XSL directly....but assuming there is not..

Are there any articles that explain for a non-developer how to create a custom gantt chart for a SharePoint site using Visual Studio 2008?


Autocomplete Colors



I have a question about the colors of the text in the drop down list of Autocomplete box. I'm trying to categorize them into 2 differents colors. For example, the autocomplete box will display the list of soft drink in the store and the color will identify them as "sold out" or "available".

The data in my database is seperated into 2 columns. The first one is the names of the soft drink, and the second columns identify them as "sold out" or "available.

The autocomplete box was implemented in my website using page method. There is a function in the code behind page, calling data from the web services.

Please let me know if there is any suggestion, guideline or any reference link to the answer of my problems.

Thank you.

Open Analytic Chart on New Page In Sharepoint


We have designed a Dashboard with single page

1. A Scorecard --Zone 1

2. Analytic Charts --Zone 2

When a person clicks on any of the KPI on Scorecard corrosponding Chart for that particular KPI is displayed in Zone 2.


So far So good

Now our client has come up with a requirement that

whenever he clicks a KPI the chart should open in a new browser window instead of Zone 2.

Is this possible in Performancepoint 2007 or Sharepoint 2007 if yes then how to accomplish this

Including Chart in ASP.NET 4



I have a web application that I built using .NET 2.0. I have loaded it into Visual Studio 2010 and changed the target .NET Framework to .NET Framework 4. I want to incorporate a Chart control into one of the pages. However, the Chart control does not show up in intellisense. In addition, when I compile the web application, I receive an error that says:

"Unknown server tag 'asp:Chart'."

This would imply to me that I have not set the target .NET Framework properly. My question is, what am I doing wrong? What am I overlooking? I want to include the new Chart control but I can't figure out how to do this

Thank you,

using jquery tooltip with asp:Chart control


I'm trying to use qtip (jquery plugin) instead of the standard tooltip control provided for the asp:Chart. I think the best way to do this is with an img map, though I don't know how to implement it. Does anyone know how to implement the img map for an asp:Chart?

Adding a Chart to a Local Report


Dear All

I have created a report as a local report which looks like this:

I'm trying to add a chart to this report and I'd like it to display something like this (so sorry for the crude drawing):

It seems like it should be quite straight forward but I've tried dragging the fields into the chart all different ways and can't make it happen. I'm using Visual Studio 2010 and here's what my list of fields from the dataset look like:


I thought ObservationYear would be the series and all the other fields would be the data but this doesn't work. It produces a chart like this which wasn't what I was hoping for:

Please could you help me understand what it is I'm doing wrong? I'm very grateful for any help/advice you might be able to provide.

Kind regards








Tooltip on SSRS Chart Bars and Columns


Is there any way to implement tooltip on bars and column of charts in sql reporting servies? 

Giving Custom Colors for Graph values in SSRS2000


Hi All,

        I am stuck here with the color for the graph values i want to give custom colors for each values present in the graph, is it possible in SSRS2000.

 Problem Statement : Suppose if i want to display two data fields as bar graph

                                 Data Fields are : Vegetable Count and Fruits Count

                                          I want Vegetable count to be in Blue Colour and I want Fruits count to be in green colour.

Any help would be appreciated.

Thanks in advance.

Anish Shenoy

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend