Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    ASP.NET


Advertisements:










SQL Reporting :: Multiple Series On Line Chart?


I want to display more than one series on a line chart. I'm producing a resultset from a stored procedure which is like this:

Type Value Date

TypeA 0.07 01/06/2006

TypeB 0.08 01/06/2006

TypeC 0.08 01/06/2006

TypeA 0.08 02/06/2006

TypeB 0.09 02/06/2006

TypeC 0.09 02/06/2006

TypeA 0.09 03/06/2006

TypeB 0.10 03/06/2006

TypeC 0.11 03/06/2006

I want a seperate series for each of TypeA, TypeB, TypeC . Is it possible to doctor the resultset to give each Type (and Value) as unique columns? Or is there another way? Or do I have to shell out for Dundas Charts.


View 4 Replies (Posted: Dec 13, 2006 06:08 PM)

Sponsored Links:

Related Forum Messages For ASP.NET category:
C# - Multiple Chart Series In Chart Control?
I am a novice programmer using ms chart control for my dashboard, I have a problem displaying chart series.

Here is my sample query & result

Sample Query: "SELECT Brand, sales, Manufacturer From TABLE"

Sample Result:

[code]....

How can I display BrandA for XValueMember & Salesvalue(10000) for YValueMembers as Series1 having a column chart type.

And to display BrandY & BrandZ for XValueMember ; Salesvalue for YValueMembers as Series2 having a line chart type.

I want my chart to have 2 Y-axis; Series1 for primary Y-axis & series2 for secondary Y-axis.

My problem here is how can I display BrandA in Series1 and BrandY,BrandZ in Series2 where the values are in the same field?

Or is it possible to set more than one data source for the chart control?

I've been working on this for two days but I wasn't able to get the desired result.

Posted: Jan 5 at 7:41

View 1 Replies!   View Related
SQL Reporting :: ReportViewer Chart With Two Y Series Group?
I am creating a column and line chart in the same chartusing reportviewer 2008.

The chart gottwo yseries 'Number ofproduct order' as column chart and label on left side of chart (unit number count)and total value of orders as line chartwith label on right side of chart (unit $ value). Month ison x axis. I am wondering whether it can be done in reportviewer.

Posted: Jan 07, 2011 12:08 AM

View 5 Replies!   View Related
SQL Reporting :: Two Series In Same Column Chart In SSRS 2008?
Is it possible to show the chart like the image in my attachement in Column Chart and in 100% Stacked Column Chart of SSRS 2008.

I like to show two series in same chart. Is it possible in SSRS 2008?

I provided the sample data to test it.

Select 'Fruits' as Category, 'Apple' as Item, 20 as Sales UNION
Select 'Fruits' as Category, 'Orange' as Item, 20 as Sales UNION
Select 'Snacks' as Category, 'Biscuits' as Item, 10 as Sales UNION
Select 'Snacks' as Category, 'Chips' as Item, 10 as Sales UNION
Select 'Snacks' as Category, 'Cakes' as Item, 40 as Sales

Posted: Jan 13, 2010 03:54 AM

View 3 Replies!   View Related
SQL Reporting :: Hide Label Series In Chart Legend?
How to hide Label of specific data series in legend ?

Posted: Oct 15, 2008 12:17 PM

View 6 Replies!   View Related
Charting - Ms Chart Multiple Series X Value Mismatch?
I'm currently developing a website that shows multiple charts that I build using data from SQL tables. I've used and followed Scott Mitchell's tutorial [URL] and K. Scott Allen's ChartBuilder class [URL] and all works well.

However when have two series that I want to show on the same Chart, if one set of data does not have all of the X values the other series does, the chart blindly puts all the data on, ignoring trying to match the X values of the other series, therefore mismatching the X values when the chart is shown.

I know that I can fiddle the data so that both sets of data have the same X values, however I'm trying to make the class handle anomalies in the data so that I don't have to worry too much about the data.

Posted: Sep 3 10 at 16:07

View 1 Replies!   View Related
SQL Reporting :: Is It Possible To Have Line And Bar Chart In A Single Chart
Is it possible tohave line and bar chart ina single chart?

Posted: Dec 22, 2009 04:21 AM

View 4 Replies!   View Related
Vb.net - Chart Labels To Display At The Data Points On Multiple Series?
I have an ASP Chart (v4) which displays the data I need perfectly. I want it to show labels at the top of the data points and I am having some difficulty with it.

Here is my code that works for both series but does not display the labels:

[code]....

Posted: Mar 9 at 15:58

View 1 Replies!   View Related
Forms Data Controls :: Adding Multiple Series Of Charts On A Same Chart Which Are At Different Location?
i am using .net framework 3.5 and visual studio 2008, i want to develope an application

for graphs and charts, so charting control 3.5 i am using.

i want to add multiple series of charts on a same chart which are at different location.How can i do it?

Posted: Mar 11, 2010 05:47 PM

View 1 Replies!   View Related
SQL Reporting :: Custom Color Of Lines In Line Chart Control On Rdlc Doesn't Work,
Cusotom color of lines in line chart control on rdlc doesn't work, i follow the give steps.

Chart Property->Data->Values->Edit->Appearance->Series Style->Fill->Color.

I wrote the given code for the color on the basis of conditions.

=Switch(Fields!Section.Value="Investment", "Red",
Fields!Section.Value="Pension", "Blue",
Fields!Section.Value="Protection", "Green",
Fields!Section.Value="Assets", "Yellow",
Fields!Section.Value="Liabilities", "Orange")

Posted: Sep 25, 2009 04:00 AM

View 2 Replies!   View Related
Web Forms :: Add Dynamic Series To Chart
I have a checkboxlist on a page and I would like to display the data from a stored procedure depending on which checkbox has been selected.
There may be more than 1 checkbox selected, up to a maximum of 8. how I can dynamically add up to 8 series to a chart depending on which checkboxes are selected?

Posted: Apr 08, 2009 09:08 PM

View 4 Replies!   View Related
How To Create Multi Series Chart Dynamically
I want to create multi series asp.net chart in dynamically.I am new one for this concept.

Posted: Mar 18 10 at 3:51

View 1 Replies!   View Related
C# - Highlight One Column In Chart Control Series?
I'm going through the ASP.NET chart controls WebSamples project but I haven't found what I'm looking for yet. So basically if I had a standard bar chart with data such as below:

John - 68%
Fred - 75%
Mary - 32%
Anne - 88%

Displaying it in one series with names as the x axis and percentages as the y, is there anyway to change or highlight the bar colour of just one, so say all the bars in the series are blue but I want to programmatically change mary's bar colour to red. Is this possible?

Posted: Jan 11 10 at 14:40

View 1 Replies!   View Related
Chart: Final Series Getting Cut Off When Setting .AxisX.Maximum?
I'm trying to bind a data table like:

month value
5 345
10 1300
12 450

to an ASP.NET Chart control. My problem is that the data table only contain months that have values while in the chart i want to show the full month range from 1st to the 12th.

So i used :

Chart1.ChartAreas["ChartArea1"].AxisX.Minimum = 1;
Chart1.ChartAreas["ChartArea1"].AxisX.Maximum = 12;

But when i do this, a part of the final series gets cut off in the middle like this.

I can avoid this issue by making the maximum 13 but that would not be appropriate since i just need to show the months of the year.

Posted: Dec 19 10 at 12:51

View 2 Replies!   View Related
Forms Data Controls :: Displaying Chart With Broken Series
I am using the Chart control that is part of the newest version of ASP.NET. In this Chart, I have 3 Spline series. Each series consists of a nullable in array (int?[]). If the element in the array is a number, I wants it point plotted. However, in the case that the value is null, I do not want it plotted. Is there a way to do this? If so, how?

Posted: Jul 14, 2010 07:38 PM

View 1 Replies!   View Related
Forms Data Controls :: Missing Points In Chart Series?
so I have 3 series that are created from Cross Table Data Bind. Unfortunately some of the points are missing. Is there an algorithm I can use to cycle through the datapoints for each series and insert empty points to the correct spots so that my data is displayed correctly?

Posted: Aug 30, 2010 04:08 PM

View 2 Replies!   View Related
Forms Data Controls :: Defining The Series Parameters For An MS Chart?
I need to defining the Series parametersfor an MS Chart.

Using the sample data below is it possible toset the X & Y value types for a graphwith alldays forthe month on the X axis and the total number of visits for each day on the Y. Are MS Charts capable of auto generating the X axis based on the extents of the data dates as well a counting the daily instances?

[code]....

Posted: Feb 25, 2010 01:17 AM

View 1 Replies!   View Related
Forms Data Controls :: MS Chart Series X Axis Not Lining Up?
I have 2 series in the same chartarea. Both contain values by year (x axis). The problem is if one series does not have data for a given year, the chart will display the first value in a series on the first tick mark whether it matches the xaxis label or not.

Example:

[Code]....

Notice the 2009 value for series1 appears in the first column and the Xaxis now has 2 2009 tick marks. How do I get the values to appear on the correct X axis marks?

Posted: Sep 17, 2010 03:09 PM

View 4 Replies!   View Related
Forms Data Controls :: The Chart Only Shows The Blue Series?
Column Chart not showing both series when value is 1

I am having trouble displaying a stacked bar chart with a Y-Value of 1.

See the mark-up below:

The first Y-Value of the first series (the RED series) is 1. The first YValue of second series (the BLUE series) is also 1. The chart only shows the blue series. If I swap them around in the mark-up it only shows the red.

The last value (when X is 6) is 2 for both series. The charts will show both colors for the value of two. I would like this behavior when the value is 1.

[code]....

Posted: Mar 28, 2011 04:04 PM

View 1 Replies!   View Related
Forms Data Controls :: ASP Chart - Hide Empty Series?
I've created a stacked bar chart - so there are multiple series in a line. The series display the value, but when the value is 0 I don't want the value to be displayed because if there are multiple 0 value is starts to look like 0|0|0|0 i.e. not very nice on the eyes. I'm wondering if there is a way i can say if the value of the series is 0 dont display the value.

Posted: Jan 18, 2010 04:17 PM

View 1 Replies!   View Related
Forms Data Controls :: StackedColumn Chart Not Showing Both Series When Value Is 1?
I am having trouble displaying a stacked bar chart with a Y-Value of 1.

See the mark-up below: The first Y-Value of the first series (the RED series) is 1. The first YValue of second series (the BLUE series) is also 1. The chart only shows the blue series.If I swap them around in the mark-up it only shows the red.

The last value (when X is 6) is 2 for both series. The charts will show both colors for the value of two. I would like this behavior when the value is 1.

<asp:Chart ID="Chart1" runat="server">
<Series>
<asp:Series Name="SeriesRed"
ChartType="StackedColumn" Color="Red">

[Code]....

Posted: Mar 28, 2011 07:26 PM

View 3 Replies!   View Related
Forms Data Controls :: Unable To Use Chart Series With Postback Query
I've got an issue with the postback property. I have a chart (Code below) which has two series pulled from a datasource.

Both series display fine but I've enabled the bars in the chart to respond to the click event and when items from the first series is selected, everything works fine. However, I try to pull the x value for the second series, which is supposed to be a date, but all I get is an interger.

[Code]....

C# Code...

[Code]....

Posted: Aug 06, 2010 08:30 AM

View 1 Replies!   View Related
Forms Data Controls :: Create Multi- Series 3D Column Chart?
how we can make Multi- series 3D column chart using ASP charts

Posted: Dec 02, 2010 07:51 AM

View 4 Replies!   View Related
Forms Data Controls :: Microsoft Chart ... View X Groups Of Values In X Series?
I've a problem for show datas in a microsoft chart (spline)I've a data with Y values for each groups (I can have X groups)each group has the same values and I've a "datatime" field that make the differenceHow Can I view X gruops (X series)??With a single serie I use:

Tmp_MappaCollection tmp_MappaCollection = new Tmp_MappaCollection();
Tmp_MappaCriteria tmp_MappaCriteria = new Tmp_MappaCriteria();
tmp_MappaCriteria = new Tmp_MappaCriteria();

[code]...

Posted: Nov 03, 2009 02:13 PM

View 1 Replies!   View Related
SQL Reporting :: Display A Specific Series?
I have a report with a line chart that displays customer data. The dataset has year, month, customer, and purchases. The data category group is by year and month. The values are purchases. The series group is by customer with the data sorted in decending order by purchases and a filter of the top 10 purchasers. This works fine as intended.Now I'd like to display just one of those customers on it's own seperate chart. Since I cannot use RowNumber in the filter, how do I accomplish this (i.e. I want to show "series 1" on a chart, "series 2" on another chart, "series 3" on another chart and so on).

Posted: Feb 22, 2010 08:38 PM

View 2 Replies!   View Related
SQL Reporting :: Microsoft Chart Control And SQL Server 2005 Reporting Services?
Any one used Microsoft Chart Control in SQL Server Reporting Service reports? Specifically the 2005 version?

Posted: Jan 07, 2010 07:46 PM

View 3 Replies!   View Related
.net - MS Chart Disable The Vertical Line
I have a graph created with MS Chart like the following picture. As you can see the vertical lines are messed up with value of the top of each bar. Here's the mark-up for the graph:

<asp:Chart ID="chtNBAChampionships" runat="server">
<Series>
<asp:Series Name="Championships" YValueType="Int32" ChartType="Column" ChartArea="MainChartArea" IsValueShownAsLabel="true">
<Points>
<asp:DataPoint AxisLabel="Celtics" YValues="17" />
<asp:DataPoint AxisLabel="Lakers" YValues="15" />
<asp:DataPoint AxisLabel="Bulls" YValues="6" />
<asp:DataPoint AxisLabel="Spurs" YValues="4" />
<asp:DataPoint AxisLabel="76ers" YValues="3" />
<asp:DataPoint AxisLabel="Pistons" YValues="3" />
<asp:DataPoint AxisLabel="Warriors" YValues="3" />
</Points>
</asp:Series>
</Series>
<ChartAreas>
<asp:ChartArea Name="MainChartArea">
</asp:ChartArea>
</ChartAreas>
</asp:Chart>

I don't want the display the vertical line because it's messed up with the value on top of the each bar. How can I disable the vertical line?

Posted: Mar 11 10 at 13:47

View 3 Replies!   View Related
Line And Points Using C# Chart Control?
I have data in data table like below.

I am trying to make graph like below using asp.net chart control (made graph in excel with some test data)

points are X and Y values. lines are linear, exponential, logarithmic and power values.

how can I make this chart in asp.net (vb.net or c#)? I am newbie to chart control.

Posted: Jul 15 10 at 17:16

View 1 Replies!   View Related
C# - Generate The Line Chart In The Web Service?
My web service needs to do generate some line charts which will then be added to a PDF report that is streamed to the client.

How do I generate the line chart in the web service?

Posted: Apr 3 10 at 8:19

View 2 Replies!   View Related
Adding A Vertical Line To An Area Chart
I'm trying to add a vertical line to an area chart like the following...

<asp:Chart id="chtTriage" Width="545" BackColor="#f2f2f2" runat="server">
<Series>
<asp:Series Name="srs" ChartType="Area" Color="LightGray">
<Points>
<asp:DataPoint XValue="0" YValues="1000" />
<asp:DataPoint XValue="5" YValues="2500" />
<asp:DataPoint XValue="10" YValues="6000" />
<asp:DataPoint XValue="15" YValues="4000" />
<asp:DataPoint XValue="20" YValues="2500" />
<asp:DataPoint XValue="25" YValues="2000" />
<asp:DataPoint XValue="30" YValues="1500" />
<asp:DataPoint XValue="35" YValues="1200" />
<asp:DataPoint XValue="40" YValues="1000" />
<asp:DataPoint XValue="45" YValues="500" />
<asp:DataPoint XValue="50" YValues="0" />
</Points>
</asp:Series>
</Series>
<ChartAreas>
<asp:ChartArea Name="chaTriage" BackColor="#f2f2f2">
<AxisY Title="Number of Dogs" Interval="1000" IntervalType="Number" IsMarginVisible="false">
<LabelStyle Font="Aerial, 8.25pt" />
<MajorGrid Enabled="false" />
</AxisY>
<AxisX Title="Triage Points" Interval="10" IntervalType="Number" IsStartedFromZero="true" Minimum="0" IsMarginVisible="false">
<LabelStyle Font="Aerial, 8.25pt" />
<MajorGrid Enabled="false" />
</AxisX>
</asp:ChartArea>
</ChartAreas>
</asp:Chart>

Posted: Mar 14 at 19:38

View 1 Replies!   View Related
C# - MS Chart Drawing Line On Incorrect Points?
I have line chart which has values :

[code]...

when we set IsValueShownAsLabel=true on y-axis it shows value 0.

but graph showing values below zero at last 0.00 before 327.78.

Because I m new user cannot upoad image have a look Chart image from below url: [URL]

Posted: Jul 26 10 at 11:19

View 1 Replies!   View Related
Web Forms :: Use SQLDataSource As Datasource In Line Chart?
It is easy to use SQLDataSource as data data source in Column chart (see code below). Is there any easy way to use SQLDATASource to fill line chart with minimum configuration? Most samples I found on the web do not use SQLDATASOURCE as data source .

[Code]....

Posted: Mar 10, 2011 06:30 PM

View 3 Replies!   View Related
SQL Reporting :: Line Graph In .rdlc / Display Line Graph For Each Product?
I have to desing line chart graph in .rdlc report, can you please help me, i have decimal values on Y-Axis and date time values on X-Axis , i have two series of product, according to product value during specific time i need to display line graph for each product.please do needfull to me.

Posted: Sep 04, 2010 07:11 AM

View 2 Replies!   View Related
Asp:Chart Set PlotArea Color Under The Line (ike Google DashBoard)
i m usingAsp.Net Chart control i musing Line Chart i need to give thecolorthe area under the line(ike google DashBoard)

Posted: Apr 26, 2010 08:13 AM

View 3 Replies!   View Related
C# - MS Chart Control Scale - Line Graph Show 12 Months?
On my X Axis, I have months. The chart shows up to 11 points, i.e. Jan - Nov of the same year, but when I add 12 points (Jan - Dec), it will do an auto label thing and change the interval for every 4 months.

How can I change the graph so that it shows 12 months before it does the auto labels?

Here is the server control code I am currently using.

[code]....

Posted: Jun 7 10 at 23:26

View 1 Replies!   View Related
Forms Data Controls :: Colum Chart Dispaly Line At Zero?
i have column chart on my page i want to disaply line at zero and all other grid lines visible false how i can i do that i amusing asp.net 4.0 chart control

Posted: Jul 08, 2010 11:33 AM

View 1 Replies!   View Related
Forms Data Controls :: Create A Line Chart From A Sql Query?
I have to create a line chart from a sql query. It is as follows:

[Code]....

However,I need to take PlayerName into account too.For example,if there are 2 differentPlayerNames,2 different series will be shown on theline chart.

Posted: Jan 28, 2011 01:22 PM

View 1 Replies!   View Related
Forms Data Controls :: Disable The Grid Inside The Line Chart?
I don't want to display the grid inside the line chart. Also I want to show a multiple lines in a single line chart(single chart displaying multiple line charts).

Posted: Jun 05, 2010 09:55 PM

View 1 Replies!   View Related
Forms Data Controls :: Fill In The Color Beneath The Line Of A StepLine MS Chart?
I need to create a chart, preferably using MS Chart Controls, that looks like a stepline chartwith the exception that color has to be filled in under the line. An area chart won't block off values like a stepline chart(it creates a direct, or curved,line from one point to another). An area chart does fill in the color the way I would like it to be but I want a stepline effect.What I guess I want is a StepArea chart. I would imaginethat it should be possiblebut I haven't been able to configure it the way I want. how I can do this?

Posted: Jul 14, 2010 02:05 PM

View 2 Replies!   View Related
SQL Reporting :: Finding A Chart Control Where Min Value Is '0' And Max Value Is '100'?
there is a chart control where min value is '0' and max value is '100' and interval time is 20. so y- axis intervals display on chart like this, 0,20,40,60,80,100. but when interval meet 80 value, there onwards intervals should be like 0,20,40,60,80,85,90,95,100. Can anyone has idea how to achieve this.

Posted: Oct 20, 2009 07:25 AM

View 2 Replies!   View Related
Copyright 2005-08 www.BigResource.com, All rights reserved