.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

Charting using Funnel Plot, Box Plot and Whisker Plot

Posted By:      Posted Date: October 20, 2010    Points: 0   Category :Sql Server


I'd like to know the best way of achieving the following within SSRS 2005; -

Box Plot; - http://support.microsoft.com/kb/155130

Whisker Plot; - http://peltiertech.com/Excel/Charts/BoxWhisker.html

Funnel plot; -  <cite>www.erpho.org.uk/download.aspx?urlid=14908&amp;urlt=1</cite>

I understand that the chart component within SSRS 2005 does not allow me to do

View Complete Post

More Related Resource Links

Plot Running total charts from SSAS Cube

Environment: I am using SQL Server 2008, I have installed SSIS, SSAS and SSRS. Objective: Create a Effort V/S Defect plot in SSRS 2008 Approach: 1. Created the SSAS cubes with Effort and Defects data by timeline (rollup of data based on Week ending date) 2. Created SSRS project and linked the dataset to SSAS cube. But i am unable to plot a Effort (X-Axis) v/s Defects (Y-Axis). As soon as i drag the measures into the query designer in dataset properties, the effort rollup will break. Following is the data that has been created in SSAS. I need to plot a graph of Hours v/s defects (Running total). Please guide me on how to plot the graph using SSRS 2008 from the already created SSAS cubes Week Of Hours Defects 10/24/2009 8   11/7/2009 63   11/14/2009 68   11/21/2009 80.5   11/28/2009 139   12/5/2009 221.25   12/12/2009 131.75   12/19/2009 124.5   12/26/2009 61.5   1/2/2010 73   1/9/2010 153.5   1/16/2010 149.5   1/23/2010 196   1/30/2010 163   2/6/2010 155.5   2/13/2010 178   2/20/2010 138   2/27/2010 161.5   3/6/2010 189   3/13/2010 191.9   3/20/2010 240.5 9 3/27/2010 260.2 5 4/3/2010 214.5 13 4/10/2010 274.6 24 4/17/2010 200.5 15 4/24/2010 227 9 5/1/2010 237.05 18 5/8/2010 190.5 12 5/15/2010 156.25 6 5/22/2010

Scatter Plot shows one point only

Hello Folks I supposed to have 600+ points for two of my variable (X and Y) however when I put it in Scatter Plot, it only shows one point. I have removed the aggregate values and leave it just as field X value. no effect. Also changing the Vertical and Horizontal axis to numeric also cannot help. Any help ? Thanks    

2 Scatter plot graphs

You cannot vote on your own post

I'm trying to plot 2 scatter plot graphs on one report using SSRS2008. One should be a regular scatter plot (disconnected dots), but another one should connect the dots into a line, or a curve.

What properties need to be set and how?

Any help will be greatly appreciated.

A flexible charting library for .NET

ZedGraph is a class library, Windows Forms UserControl, and ASP web-accessible control for creating 2D line, bar, and pie graphs of arbitrary datasets. The classes provide a high degree of flexibility - almost every aspect of the graph can be user-modified. At the same time, usage of the classes is kept simple by providing default values for all of the graph attributes. The classes include code for choosing appropriate scale ranges and step sizes based on the range of data values being plotted. Moreover, ZedGraph is compatible with .NET 2.0, and VS .NET 2005.

Foundations: Charting with DataTemplates


For WPF programmers, one major revelation about the power of the DataTemplate comes with a demonstration of how XAML can turn business objects into bar charts. This column explores how to use DataTemplates to create different types of charts.

Charles Petzold

MSDN Magazine September 2009

Extreme ASP.NET: Charting With ASP.NET And LINQ


The combination of the ASP.NET Chart Control and the data querying power of LINQ lets you build flexible charts. Learn how here.

K. Scott Allen

MSDN Magazine March 2009

Toolbox: Code Generation, A Charting Component, and More


Developers have a number of tools at their disposal, but which of these components do you really need to complete your project? Each month we'll analyze the latest software and books to see if they merit inclusion in your toolbox.

Scott Mitchell

MSDN Magazine January 2006

wpf charting column series data binding problem

I'm trying to build a chart using the columnSeries from the wpf toolkit and I appear to be having trouble with the data binding. Here is the xaml: <Grid>    <chartingToolkit:ColumnSeries Height="18" HorizontalAlignment="Left" Margin="188,169,0,0" Name="columnSeries1" VerticalAlignment="Top" Width="18" IndependentValueBinding="{Binding Path=Date}" DependentValueBinding="{Binding Path=Value}" /></Grid> In the code behind, I'm calling a stored procedure and putting the result in a datatable like this: string connString = ConfigurationManager.ConnectionStrings["string"].ConnectionString;            using (SqlConnection cn = new SqlConnection(connString))            {                DataTable dt = new DataTable("T1");                cn.Open();                SqlCommand cmd = new SqlCommand("T1_sp", cn);                cmd.CommandType = CommandType.StoredProcedure;                  SqlDataAdapter da = new SqlDataAdapter(cmd);                da.Fill(dt);                columnSeries1.ItemsSource = dt.DefaultView;                cn.Close();            } No error is being generated but I'm not getting a column chart either. If I take the same command and put it into a datagrid, it works fine. What do I need to do to get this into my column chart? If it helps,

Wpf Charting for Large Data

Hi, Currently I am working on Charting control. Here I need to display 10000 data's using LineChart which is provided by the toolkit. But unfortunately the application gets slow because of this huge data. I tried using Dynamic Data Display which is provided by codeplex. Since it is in beta stage, is there any other way I could accomplish this without affecting the application performance. Please help me. Regards, Raaj

.net charting displaying a value in a legend

Hi All,Is this possible? To display a value in a legend. Here is my code: <Legends> <asp:Legend IsTextAutoFit="False" Name="Default" BackColor="Transparent" Font="Helvetica, 8.25pt, style=Bold"></asp:Legend> </Legends> <series> <asp:Series Name="YTD" IsVisibleInLegend ="true" XValueMember="slspsn_no" YValueMembers="sls_ytd" IsValueShownAsLabel="true" ChartType="Column" ToolTip="YTD Sales" LabelToolTip="Year to Date sales for the rep."> </asp:Series> <asp:Series Name = "GoalToPeriod" IsVisibleInLegend = "true" XValueMember="slspsn_no" YValueMembers = "GoalToPrd" IsValueShownAsLabel = "true" ChartType = "Column" ToolTip = "Goal to Period"></asp:Series> <asp:Series Name ="Goal" YValueMembers="GoalSls" XValueMember="slspsn_no" IsValueShownAsLabel="false" ChartType="Column"> </asp:Series> <asp:Series Name="SLS Last Year" XValueMember="slspsn_no" YValueMembers="sls_last_yr" IsValueShown

WPF toolkit charting control



we have generated the charts using WPF toolkit charting control.

Would it be possible to save the charts on screen into a Excel 2003 file by pressing a button?


Asp.Net Charting Control - Z axis


From the documentation i have read so far, it appears to me that i cannot add a 3rd dimension to the chart. I was looking for a confirmation of this and if there was any other avenue available for me to make charts that look similar to the ASP.NET chart control (visually) but allow me to add a z-axis.


Charting... Working, but not! :-S




I am reporting data to a page called statistics.aspx and am trying to use the ASP.Net 4 Chart Control. It works when I run it through Debug in Visual Studio and shows no build errors but throws a server 500 error without stack trace in the live environment. I'm really confused about what to do because It's running fine on localhost and the rest of the site functions as normal in the live environment. :-S


Is there something special that needs to be setup in IIS 7 (.5) for charts to work?


Help! I really have no idea where to go from here.

HELP! - asp.net Charting...


Okay, I don't know if this is a .NET thing, an IIS thing, or a stupid mistake in my code...

I am using the charts web form control and it looks amazing when I am looking at it in debugging mode in Visual Studio. It returns no errors in the build either. But when I go to view the page outside of VS and debugging... I get...

500 - Internal server error.

There is a problem with the resource you are looking for, and it cannot be displayed.


My statistics page looks like this:


<%@ Page Title="Customer Statistics" Language="VB" MasterPageFile="~/Site.master" AutoEventWireup="false" CodeFile="Statistics.aspx.vb" Inherits="Statistics" %>

<%@ Register assembly="System.Web.DataVisualization, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35" namespace="System.Web.UI.DataVisualization.Charting" tagprefix="asp" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
    <br />
    <br />
<asp:Chart ID="Chart1" runat="server" 

Flow charting diagram in vb.net (basic visio type of program) Create a drawing


I have a program that I wrote that allows user to create a process flow


Station A A Debug A Rework
Station B B Debug
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