.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

Pie Chart - Fixed Value Legend

Posted By:      Posted Date: September 15, 2010    Points: 0   Category :Sql Server
Hi All, I have a problem with Pie Charts in Reporting Services which i cant seem to find a solution for. My Pie chart is displaying the percentage of priorities for certain events for each month (See sample data below). As the priority bands are fixed (i.e an event can either be priority 1, 2 or 3), what i would like to do is show each priority in the Legend of each pie chart, regardless of whether that month contains and data for that priority. I would also like to specify a colour for each priority so that the legend for each months pie chart would show Priority 1 (Red), Priority 2 (Green) and Priority 3 (Blue).   Month - Priority 1 - Priority 2 - Priority 3 June - 5 - 2 - 3 July - 5 - 0 - 5 Aug - 0 - 10 - 0   Currently the legends for the above data would show:   June - Priority 1 (Red), Priority 2(Green), Priority 3(Blue) July - Priority 1 (Red), Priority 3(Green) August - Priority 2 (Red)   As mentioned above this omits the priorities which have a 0 value for that month, meaning when viewing the three rendered pie charts, the colours of each priority will potentially change. I hope ive explained the situation well enough, and if anyone can offer a solution or point me in the right direction id be very apprechiative.   Thanks, Sam.

View Complete Post

More Related Resource Links

How to align data in Chart legend in SSRS 2008?

Hi,I have created a chart of type 3D pie.  I put a String field for Category and Sum(numeric field) for Data.I wanted to show the legend as Category field and Data field and it's displaying as i set.Now how to make alignment of Data in legend, so that my numeric fields should align Right and String field should align Left.  I can make whole legend alignment but I want to make only the numeric field in the legend to align Right.Is it possible or there any work around?Please let me know.

how to show specific data label or legend in the line chart


I have a line chart with date (X axis) for average numbers. I wanted to show only one number for the month at the chart or legend area. But i can show or hide whole data labels. Is it possible to have an expression box in chart area?

Thanks in advance,


3-D column chart - Y - Axis Labels -Instead of Legend



I am having a 3d Column chart in my report but I am not able to show the Labels on the right hand side. as for right hand side it shows only LEGENDs ,not Labels property.

Please have a look at the chart in this like


In this  example

I am able to show the sales figures (Z-axis) and promotion type (X-axis),

but not able to show the date shown in  (Y-axis)

I don't know how to set the labels for Y-axis in this kind of chart.I dont want to show legend as its of no use same color is coming for all Years.

Any help on this.



SSRS Hide one data value label in chart legend

Is it possible  to hide one value in the legend? I've got a stacked bar chart, but there's one value that I don't want to display in the Legend. Is it possible to hide this particular color and label in the legend?


Chart Control Legend


Here is my dilemna. I am using a Chart Control, and I have 2 series. In my case 1 for month and 1 for year. The problem is when the chart control is displayed during run time for some reason the legend has 4 entries 1 says Mont, 1 says Year, 1 says Series 1, and 1 says series 2. My question is why are there 4 entries for the legend? Thanks for any Help. It would be Greatly Appreciated.

How do I add a legend to an ASP.NET 3.5 chart control?


Is there a way to add a legend to the chart it creates? I have created a line chart and by default it has created different colors for the different y - axis data.

I would like a legend on the side that displays what data goes with which line color.

Thank You.

How to Fixed GridViews Header and Footer when scrolling in asp.net?

This article is to show you how to Fix GridView''s Header and Footer in a simple code with CSS and JavaScript

Scrollable GridView with fixed headers in asp.net C# vb.net

In this example i am going to show how to create scrollable GridView with fixed headers which don''t get scrolled with records and stay on the top in asp.net using css, I''ve tested this code on IE7 and Firefox 2.0 , 3.5.

For this we need to add css to headers of gridview to keep them on the top.

First of all place a Panel on the aspx page from thetoolbox. Set height to 200px and width to 200px
and scrollbars to Vertical.
Now add a gridview inside this Panel and set the datasource to populate gridview.

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

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?


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?

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