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

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

Combine 100% stacked bar charts onto one chart

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :Sql Server
Hi All: I have eight questionaires for likert scale (Strongly disagree, disagree, netural, agree and strongly agree). I try to create a 100% stacked bar chart that X axis would be eight questionaires and Y axis is the pecentage.  I couldn't get it work. What I did was to create a single 100% stacked bar chart for each questionaire. That's not the way I want and does anyone know how to create this type chart? Thanks in advance.      

View Complete Post

More Related Resource Links

Stacked Column Chart: Workaround for busted InsertEmptyPoints

I had to struggle with this a bit so I'm gonna share what I figured out. To make a stacked column chart from a SqlDataSource you need to use DataBindCrossTable like this... CHART1.DataBindCrossTable(SqlDataSource1.Select(DataSourceSelectArguments.Empty), "proceso_estado_nombre", "max_fecha_final", "valor", "") Now, each series created needs to be converted to StackedColumn type, which you do like this... For Each series As DataVisualization.Charting.Series In CHART1.Series    series.ChartType = DataVisualization.Charting.SeriesChartType.StackedColumnNext The problem at this point is that the chart wont work if you don't have the same number of points in each series and each set of points should have the same X values. So to fill in the empty points in each series you can use InsertEmptyPoints like this... CHART1.DataManipulator.InsertEmptyPoints(1, DataVisualization.Charting.IntervalType.Months, series.Name.ToString) However, when I did this I got inconsistent results. See below... <Series>    <Series Name="Terminado" Legend="Default" XValueType="Date" ChartType="StackedColumn" ChartArea="ChartArea1" ToolTip="Terminado: #VALY{C0}">      <Points>      

[RS 2008 R2] Advice for Multi-series stacked chart



I need an advice about the layout of a multi-series stacked chart (which I hope is the correct way to realize my report). The data I need to draw has the following structure (aggregations have already been calculated in the database query due to the high amount of data):

Date             Priority    Value
2010-09-19   A             48
2010-09-19   B             50
2010-09-19   C             45
2010-09-19   TA A        11
2010-09-19   TA B        18
2010-09-19   TA C        2
2010-09-19   Total        143

The chart must contain Date on X axis, the Value on Y Axis and stack in the same chart area 7 different graphs according to priority field:
- 4 must be line graph (Priority = A, B, C, Total)
- 3 must be column graph (Priority = TA A, TA B, TA C)

Here follows the way I conceived the chart:
- Date field goes into Category Groups
- Priorit

Pie Charts rendering outside chart window



I hope someone can help me.  I have a report that uses several charts and while they render fine in SSRS, when I deploy them the Report Manager shows the pie charts that are too big and fall outside of the chart window. Also, when I run them though our report.aspx page I am getting charts that duplicate and fall outside the entire parameters section.  Now I can't get to the export drop down option because the duplicated charts are covering it.  Not sure if this makes any sense. 

Anyway it is my guess that the charts are fine (since they look ok in ssrs) so it is something in my report.apsx page or some configuration that is messed up.


Again thank you in advance for any help...

How do I create a stacked column chart over yrly/mo series/category?




I would like my output to look like this:

2009          2010


|__c__|    | __b__|    

|__b _|   |   a      |

|   a   |   | _____|


where both of the stacked bars represent data for the month of January such that each month would have it's own two years worth of stacked bar data...please help.

Stacked Bar chart missing percentage sign



I hope someone can help me. I have used a Stacked bar chart in SSRS 2008. This chart shows the percentage but without the "%" sign.
It's not showen in de datalabel and also not in the axis. I have tryed to format but with a P0 it multipy by 100. Ideas?



Conditionally Hide Percentage Labels on a 100% Stacked Bar Chart SSRS

I have searched for answers on this topic and the only ones I can find are for pie charts.  What I'd like to do is hide the point labels (percentages) on a 100% stacked bar chart when the percentage is below .05%, otherwise the labels are very cluttered and difficult to read.  I have tried to write an expression to do this, however, since the percentage calculation goes on behind the scenes I cannot find a way to refer to this value.  In addition, I am using #.## "%" for my formatting and am wondering if there is a way to remove the % sign when the label is hidden. Any help would be appreciated.  Thanks.

show customized groups in series field in a stacked bar chart



Here I have one doubt, need your help.

I am creating a stacked bar chart in report designer, and I have created the Dataset.

For instance: I drag and drop Count to data field, year to the category field, createdby to the series field. Now I assume that createdby have values: v1,v2,v3,v4,v5,v6. I want to group v1,v2 into Value1, and show in green color; meanwhile group v3,v4,v5 into Value2, show in red color. and do not show v6.

In the final stacked bar chart, I want only Value1 and Value2 shown in series field.

Can you tell me how can I filter v6 and create the two groups? thanks!


Connie Zhu

Show multiple values in stacked bar chart tooltip



I have a stacked bar chart showing my values by geographical region. Within each region I have x-number of DataAreaIDs. I want the user to be able to see the distinct DataAreaIDs via a mouse over on each bar.

I therefore entered this formula in the tooltip option for the regional bar but it only displays #Error: "=join(Fields!DataAreaID.Value,", ")".

I appreciate your help!


Combine, minify and compress JavaScript files to load ASP.NET pages faster

Websites are getting more interactive these days and most of this interactivity comes from JavaScript. People are using different JavaScript libraries and frameworks to make their websites more interactive and user friendly.

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..


Extreme UI: Line Charts with Data Templates


Charles Petzold continues his investigation into robust XAML coding made possible by Windows Presentation Foundation, this time tackling the complicated process of creating line charts.

Charles Petzold

MSDN Magazine January 2010

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

What Gives You the Right?: Combine the Powers of AzMan and WSE 3.0 to Protect Your Web Services


In this article, Niels Flensted-Jensen demonstrates how you can combine new and existing Microsoft technologies with minimal new code to provide flexible authorization for individual Web service methods. Windows 2003 Authorization Manager, Web Service Enhancements 3.0, and Enterprise Library all play a part.

Niels Flensted-Jensen

MSDN Magazine November 2005

Web Services: Increase Your App's Reach Using WSDL to Combine Multiple Web Services


The very tools that have helped drive the growing adoption of Web services, and the enabling abstractions that they provide, can often prevent developers from peeking behind the curtains at the XML standards that make up the Web services stack. This article will offer a solution that enables type sharing between proxies created for complementary Web services, while at the same time providing an opportunity to examine the Web Services Description Language (WSDL) and its interaction with the Web services tools you know and love.

Gerrard Lindsay

MSDN Magazine March 2005

ASP.NET: Combine Web and Windows Services to Run Your ASP.NET Code at Scheduled Intervals


If you want to schedule ASP.NET tasks, one solution is to use a Web service to provide an interface to your ASP.NET application and build a Windows service that calls to it at scheduled intervals. Thus the ASP.NET application doesn't have to own the scheduling logic. Here the author shows how to schedule your ASP.NET tasks using a Windows service to initiate the Web service call because Windows services can start themselves when Windows boots up.

Andrew Needleman

MSDN Magazine March 2005

ASP.NET: Create Snazzy Web Charts and Graphics On the Fly with the .NET Framework


Knowledge workers can understand data more effectively when raw numbers are presented in a graphical format. This is especially true when displaying database information on a Web page, where a simple chart can make the difference between a dry presentation and a vivid data source. In the past, creating dynamic, data-based charts on the fly in ASP required purchasing a third-party, image-generating COM component. Now with ASP.NET, developers can access the .NET Framework's drawing classes directly with C# to create dynamic images and charts.

Scott Mitchell

MSDN Magazine February 2002

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