SQL Reporting :: Multiple Series On Line Chart?

Dec 13, 2006

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.



ADVERTISEMENT

C# - Multiple Chart Series In Chart Control?

Jan 5, 2011

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.

View 1 Replies View Related

SQL Reporting :: ReportViewer Chart With Two Y Series Group?

Jan 7, 2011

I am creating a column and line chart in the same chart using reportviewer 2008.

The chart got two y series 'Number of product order' as column chart and label on left side of chart (unit number count) and total value of orders as line chart with label on right side of chart (unit $ value). Month is on x axis. I am wondering whether it can be done in reportviewer.

View 5 Replies View Related

SQL Reporting :: Two Series In Same Column Chart In SSRS 2008?

Jan 13, 2010

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

View 3 Replies View Related

SQL Reporting :: Hide Label Series In Chart Legend?

Oct 15, 2008

How to hide Label of specific data series in legend ?

View 6 Replies View Related

Charting - Ms Chart Multiple Series X Value Mismatch?

Sep 3, 2010

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.

View 1 Replies View Related

SQL Reporting :: Is It Possible To Have Line And Bar Chart In A Single Chart

Dec 22, 2009

Is it possible to have line and bar chart in a single chart?

View 4 Replies View Related

Vb.net - Chart Labels To Display At The Data Points On Multiple Series?

Mar 9, 2011

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

View 1 Replies View Related

Forms Data Controls :: Adding Multiple Series Of Charts On A Same Chart Which Are At Different Location?

Mar 11, 2010

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?

View 1 Replies View Related

SQL Reporting :: Custom Color Of Lines In Line Chart Control On Rdlc Doesn't Work,

Sep 25, 2009

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")

View 2 Replies View Related

Web Forms :: Add Dynamic Series To Chart

Apr 8, 2009

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?

View 4 Replies View Related

How To Create Multi Series Chart Dynamically

Mar 18, 2010

I want to create multi series asp.net chart in dynamically.I am new one for this concept.

View 1 Replies View Related

C# - Highlight One Column In Chart Control Series?

Jan 11, 2010

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?

View 1 Replies View Related

Chart: Final Series Getting Cut Off When Setting .AxisX.Maximum?

Dec 19, 2010

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.

View 2 Replies View Related

Forms Data Controls :: Displaying Chart With Broken Series

Jul 14, 2010

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?

View 1 Replies View Related

Forms Data Controls :: Missing Points In Chart Series?

Aug 30, 2010

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?

View 2 Replies View Related

Forms Data Controls :: Defining The Series Parameters For An MS Chart?

Feb 25, 2010

I need to defining the Series parameters for an MS Chart.

Using the sample data below is it possible to set the X & Y value types for a graph with all days for the 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]....

View 1 Replies View Related

Forms Data Controls :: MS Chart Series X Axis Not Lining Up?

Sep 17, 2010

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?

View 4 Replies View Related

Forms Data Controls :: The Chart Only Shows The Blue Series?

Mar 28, 2011

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

View 1 Replies View Related

Forms Data Controls :: ASP Chart - Hide Empty Series?

Jan 18, 2010

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.

View 1 Replies View Related

Forms Data Controls :: StackedColumn Chart Not Showing Both Series When Value Is 1?

Mar 28, 2011

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

View 3 Replies View Related

Forms Data Controls :: Unable To Use Chart Series With Postback Query

Aug 6, 2010

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

View 1 Replies View Related

Forms Data Controls :: Create Multi- Series 3D Column Chart?

Dec 2, 2010

how we can make Multi- series 3D column chart using ASP charts

View 4 Replies View Related

Forms Data Controls :: Microsoft Chart ... View X Groups Of Values In X Series?

Nov 3, 2009

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

View 1 Replies View Related

SQL Reporting :: Display A Specific Series?

Feb 22, 2010

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

View 2 Replies View Related

SQL Reporting :: Microsoft Chart Control And SQL Server 2005 Reporting Services?

Jan 7, 2010

Any one used Microsoft Chart Control in SQL Server Reporting Service reports? Specifically the 2005 version?

View 3 Replies View Related

.net - MS Chart Disable The Vertical Line

Mar 11, 2010

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?

View 3 Replies View Related

Line And Points Using C# Chart Control?

Jul 15, 2010

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.

View 1 Replies View Related

C# - Generate The Line Chart In The Web Service?

Apr 3, 2010

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?

View 2 Replies View Related

Adding A Vertical Line To An Area Chart

Mar 14, 2011

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>

View 1 Replies View Related

C# - MS Chart Drawing Line On Incorrect Points?

Jul 26, 2010

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]

View 1 Replies View Related

Web Forms :: Use SQLDataSource As Datasource In Line Chart?

Mar 10, 2011

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

View 3 Replies View Related

SQL Reporting :: Line Graph In .rdlc / Display Line Graph For Each Product?

Sep 4, 2010

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.

View 2 Replies View Related

Asp:Chart Set PlotArea Color Under The Line (ike Google DashBoard)

Apr 26, 2010

i m using Asp.Net Chart control i m using Line Chart i need to give the color the area under the line(ike google DashBoard)

View 3 Replies View Related

C# - MS Chart Control Scale - Line Graph Show 12 Months?

Jun 7, 2010

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

View 1 Replies View Related

Forms Data Controls :: Colum Chart Dispaly Line At Zero?

Jul 8, 2010

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 am using asp.net 4.0 chart control

View 1 Replies View Related

Forms Data Controls :: Create A Line Chart From A Sql Query?

Jan 28, 2011

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 different PlayerNames,2 different series will be shown on the line chart.

View 1 Replies View Related

Forms Data Controls :: Disable The Grid Inside The Line Chart?

Jun 5, 2010

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

View 1 Replies View Related

Forms Data Controls :: Fill In The Color Beneath The Line Of A StepLine MS Chart?

Jul 14, 2010

I need to create a chart, preferably using MS Chart Controls, that looks like a stepline chart with 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 imagine that it should be possible but I haven't been able to configure it the way I want. how I can do this?

View 2 Replies View Related

SQL Reporting :: Finding A Chart Control Where Min Value Is '0' And Max Value Is '100'?

Oct 20, 2009

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.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved