Show Sales In Various Categories In A Chart?
May 14, 2010
The problem is that we have 5 different categories and we have to calculate the percentage of products sold in each category. Then we have to show that in sort of a chart. The interface of chart is shown here
http://img64.imageshack.us/img64/5397/52805880.gif although this chart has 14 boxes but I will be using 20 boxes in the final chart, the reason for that is that I want each box to represent 5% of sales. Now the question is suppose that the percentage for sales in each category is 34.4%, 12.6%, 23.2%, 22.6% and 7.2%. How do I convert these values to nearest 5 and then fill each box with that color. For example 34.4% means that almost 35% or 7 boxes will be colored with that color. The problem is that the sum of all of these must always be 20. I understand that this will not be very precise representation but this is the demand from the user.
View 4 Replies
Similar Messages:
Mar 16, 2011
I have a grid view to show a listing of domestic sales and international sales. I share the same grid view for both. So if i select 'Domestic' radio button, i have to change the label of first column as 'SalesNo' and also set the sort expression as 'sales_No', if i select 'International' radio button, i have to change the label of first column as 'ExportNo' and also set the sort expression as 'export_No'. How can i do it using C# ?
View 1 Replies
May 7, 2015
I have a table where I have
Amount paid, payment date
I want to write a query which will fetch the total amount of sales for a month based on the payment date.
And i want to represent the result in a pie chart like january(3000),february(90000),march(20000) etc.
View 1 Replies
Jan 9, 2010
I want to add unlimited categories and sub categories facility, But I couldn't solve it for last two days.
1. DB
CategID,CategName,parentid
Data:
CategID CategName Parent ID
1 Electronics 0 (where 0 means it is main category)
2 TV 1 (Self Join whith the categ id Electronics)
3 Panasonic 2
4 LG 2
5 Toys 0
6 Girls Toys 5
7 Boys Toys 5
8 Criket Related 7
9 Dolls 6
Here I want to display this data in Combo Box like
Electronic
>>TV
>>Panasonic
>>LG
Toys
>>GirlsToys
>>Dolls
>>Boys Toys
>>Criket Realted
View 6 Replies
Jan 21, 2010
I am building a little app to upload a picture and various downloads for different file types for the photos, but I also need be able to select the catergory they will go into. So I have two tables one that stores the catergory names and one that holds the paths to the photos and downloads the tables are related through the catergoryID.
What I need is those catergories to show up in the photo's and downloads table so that when I go to upload the photos I will be able to select the categories.
I have also built the DataSet and the Business Logic.
View 3 Replies
Mar 9, 2010
I am using the new ASP control "Chart", but I have some problems with it: I can't see anything when I execute the aspx. The data is binded to a ObjectDataSource, like this:
<asp:Chart ID="RcrBufferChart" runat="server" Visible="true"
DataSourceID="RcrBufferSizeODS" BackColor="WhiteSmoke" BackGradientStyle="TopBottom"
BackSecondaryColor="White" Palette="BrightPastel" BorderDashStyle="Solid"
BorderColor="26, 59, 105" Height="583px" Width="1159px" >
<borderskin skinstyle="Emboss"></borderskin>
<series>
<asp:series Name="Series1" ChartType="Spline" ShadowColor="Black"
BorderColor="180, 26, 59, 105" Color="224, 64, 10" IsValueShownAsLabel="True"
XValueMember="CreationDate" XValueType="DateTime" YValueMembers="Size"
YValueType="Double"></asp:series>
</series>
<chartareas>
<asp:ChartArea Name="ChartArea1">
<AxisY Title="Tamaño RCR sin enviar">
</AxisY>
<AxisX Title="Fecha">
</AxisX>
</asp:ChartArea>
</chartareas>
</asp:Chart>
<asp:ObjectDataSource ID="RcrBufferSizeODS" runat="server"
SelectMethod="GetByAppliance"
TypeName="Esabe.Grazalema.Business.RcrBufferSizes">
<SelectParameters>
<asp:QueryStringParameter Name="serialNumber" QueryStringField="SerialNumber"
Type="String" />
</SelectParameters>
</asp:ObjectDataSource>
but the result I get is the following: Does anyone know why it isn't showing anything?
View 1 Replies
Oct 15, 2012
I have a column in gridview which displays float values. But while the same value in chart I need to round off to nearest whole number and display it in chart.
i.e if it is 12.6745 then it should be 13Â Â
<asp:Series IsValueShownAsLabel="True" Legend="Legend1" Name="(%)"
XValueMember="Test" YValueMembers="PERCENT">
</asp:Series
View 1 Replies
Jan 19, 2011
I m having a problem in showing chart with datatable. I want to show my chart as shown in below image. How can i do this in ASP.net using MS chart controls
View 3 Replies
Jul 28, 2010
I'm developing a stocks evolution chart with Microsoft Chart Controls and I need to show the initial and final dates on the AxisX labels but I can't do it.
I google and found many solutions like set the properties:
Chart1.ChartAreas[0].AxisX.Minimum = InitialDate.ToOADate();
Chart1.ChartAreas[0].AxisX.Maximum = FinalDate.ToOADate();
Chart1.ChartAreas[0].AxisX.LabelStyle.IsEndLabelVisible = true;
Nothing made same differnce.
On the sample below the initial date was Jul 26, 2007 and the final was Jul 26, 2010, this is what I need to show on the chart labels, the others dates don't make difference and can be showed in any interval.
View 1 Replies
Mar 1, 2010
I have Bar Chart with two Series on X axis one for Month and Other for Productvalue now if the product value is Zero then nothing is displaying on graph is there any way to show the atleast value of the product as integer Zero.
View 3 Replies
Oct 6, 2010
I'm trying to create a very simple Column chart. There are 10 items in X axis, but chart shows only 3 of their labels. For clarification, I'm trying to show Product sales count in chart. There are 10 products. In X axis, chart shows 10 products but, only 3 of them has a label for product name. It should be a setting for this, bu I couldn't find it.
View 2 Replies
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
Jan 28, 2013
I have a simple chart control on my form. it displays data fine in X and Y axis. On X axis, i have time period (1 day,1 week, to 30 Years- total of 27 points on x axis) and Y axis has interest rate.
when the cursor is moved in the chart area, I want to show the exact value of Y axis. Just like yahoo finance shows when we click on a graph of a stock symbol. Say on my chart, when user hovers on say 2 Y on the graph, it should show the exact interest rate which is on the Y axis.
View 1 Replies
Nov 17, 2010
I´ve got a chart control (column type) and must show many elements at y axis, but when system generates the chart draw, it´s shows only odd elements: For example: My chart must show a colunm containing systems (x) and error incidences (y):
1. SIEMP
2. SISOUT
3. SIGTI
4. SISFIN
5. SISPL
6. SISTER
But it´s only shows:
1. SIEMP
2.
3. SIGTI
4.
5. SISPL
6.
I must set a parameter that forces "all" series to be showed.
View 2 Replies
Feb 22, 2010
I would like to populate a dropdownlist with all users who are in the Sales role. I am using the .Net Membership and Roles tables in my SQL 2005 DB (aspnet_Users, aspnet_Roles...).
View 3 Replies
Apr 27, 2010
How To Compare Two Tables Qty Based On Purchase and Sales?
View 3 Replies
Apr 19, 2010
Im using asp.net 2.0 with Visual studio 2005... My requirement is i want to show my balance sheet from MS SQL 2005 database to graphical Chart... so Would u guyz will let me know the best high qulaity chat which support asp.net 2.0 with Visual studio 2005..
View 3 Replies
Jan 16, 2014
I want to find the sum of sales column from the table. Like today is 16-01-2014, i want the sum of sales column of 7 days back i.e. till 09-01-2014. I cannot put static dates as everyday date will change and every day i want that query to automatically see 7 days back records.
View 1 Replies
Mar 18, 2010
I have 200 record in reportviewer chart but show only first page not showing remaing page
what setting need to do in order to see remaining pages
View 2 Replies
Feb 11, 2013
I have a simple .aspx page.
I want to show the data either in Chart control or Gridview control. When the user selects an option to see the data either in chart control or grid view control, that specific control has to show up and other control has to become invisible.
So far, I am able to populate data successfully in the chart control. If the user chooses "Grid view" option, how can I show the data in grid view control in the same location. I don't want the gridview control to be shown in a pop up window or any other window.
View 2 Replies
Jul 9, 2010
I have an issue in using dot net chart control. In chart last column is not completely shown which give bad appearance and on right side of chart it looks like TickMark are enabled. I set MajorTickMark of AxisY2 disabled but still tick marks on right side.
View 2 Replies
Feb 24, 2010
how to freeze the x axis of the chart control in ms chart? need to use because data displayed at large amount that is scrollable.
View 1 Replies
Jan 28, 2011
I have a drop downlist,and next to it there is an MS bar chart.i want to change the datate of the MS chart ,once the user selects another year from the dropdownlist.
When the page loads ,the chart displays the default year(2011) and it works.The problem is that is does not change the data when you select another year from the dropdownlist.
View 1 Replies
Apr 28, 2010
Am I going mad/blind? Probably a combination of the two.
How does one go about removing the data labels from a pie chart with the new chart control in .net 4?
I can get these to display as tooltips absolutely fine, but ultiamtely I'd like the labels not to be present as it looks rather busy.
I've searched previous answers and seen code behind resolutions but surely there must be some sort of code infront option to turn these labels off?
View 2 Replies
Aug 12, 2010
I am using MS Chart control (3.5), and have a requirement where I need to display 2 pie charts. The datapoints for the pie charts is set programatically. My doubts are as follows:
1. Can I display both the pie charts in a single chart control and area, or do I have to use two controls? (Currently I am using two controls)
2. How can I maintain the same size for both the pie charts? This is my main concern, since the pie sizes keep changing, depending on the number of datapoints. I tried using custom properties like "MinimumRelativePieSize", but it's not working.
View 1 Replies
