.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

3-D column chart - Y - Axis Labels -Instead of Legend

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


I am having a 3d Column chart in my report but I am not able to show the Labels on the right hand side. as for right hand side it shows only LEGENDs ,not Labels property.

Please have a look at the chart in this like


In this  example

I am able to show the sales figures (Z-axis) and promotion type (X-axis),

but not able to show the date shown in  (Y-axis)

I don't know how to set the labels for Y-axis in this kind of chart.I dont want to show legend as its of no use same color is coming for all Years.

Any help on this.



View Complete Post

More Related Resource Links

MS Chart Control ( Does not display all labels in X Axis - Column Chart )



I am facing one problem while using MS Chart Control.. In Column Chart When i am finding minimum no of records chart displays properly.

But When i finding more than 20 records, in X Axis records display randomly(i have 20 records, chart is coming but x axis labels does not appear for all 20.it display 4 or 5 lables only) .. I increased the chart size also. Still it is happeing...

Any one give me idea about to fix this problem..

Thanks in Advance.

Dual values in Column chart Y axis in SSRS 2008

Hi,  Any one pls tell me how to show dual values in Column chart Y axis. Example: Im showing Total Number of clients in the Y axis of column chart My Requirement is In that Y axis column chart also  i want to show differently of Inactive clients from total number of clients. how to do this pls help me. Thanks in advance. TotalnumberOf clients :  1000 InActive Clients : 200 among TotalnumberofClients      

Alternate lables are displayed along x axis in chart web part for column chart type

HI I am using Chart webpart of Sharepoint 2010. I am connecting this webpart to my custom list having two coulmn Title  (string) and Count (numeric) and using Column chart type i am displaying data in web part. Each column in chart represents one item in list and displyed along x axis, while y axis represents count. For more than 9 columns in column chart (i.e. more than 9 itmes in list) in chart web part only alternate lables are displyed along x axis. Any help in this will be appreciated.

Chart Control 3.5 - X-axis Labels

I have a fairly basic line graph which is bound to a SQLDataSource control.  The graph displays perfectly, but I want the labels on the X-axis to display vertically rather than horizontally.I have used the following code to try and do this but it is having no effect:<AxisX Title="Patient Safety Submissions" IsLabelAutoFit="True">    <LabelStyle Angle="90" interval="1" /></AxisX>Can anyone help?Here is the complete code for my chart:<asp:Chart ID="chrtHHcompliance" runat="server" DataSourceID="sqlHHcompliance" Width="1000px">                    <Titles>                        <asp:Title Font="Microsoft Sans Serif, 12pt, style=Bold, Underline"                                    Name="Title1" Text="Hand Hygiene Weekly Percentage Compliance">                 &nbs

How to redisplay a category-axis on a column chart after it has been deleted.


Hi All,

This should be simple, but I'm tearing my (limited) hair out trying to solve this.  I have a combined column chart (primary Y axis) and line chart (secondary Y axis) in which the category-axis (X-Axis) was deleted.  Now I want the X-Axis to re-appear.  I can't seem to find an option for re-applying the X-Axis after it has been deleted.

How do I do this?




Line chart Category Axis labels not displaying


I've got a few series of data (counts) that I've summed by month and year. So, the data looks like 

Value 'June 2010' 'July 2010', ....

Open       3                5  ...

Closed     6                10....


I've got a line chart of this data. The issue I have is on the category axis, I have the months as the value. However, only a couple of the 12 months are being displayed. The chart is populating properly, but I want every month to list out on the category axis. How can I do this, since my category type is a string? What should I set the interval, etc. to? This seems pretty basic, so I must be missing something simple.



Missing labels in chart bar the X axis


Hi All

I have a report with a bar chart. Within each category of the bar chart I have 3 bars that are compared with each other.

The problem is that not all the categories labels are shown, even though there is enough free space on the axis (the font is very small).

Can I configure the chart thus all the values will apear?

Thank you.



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


Chart X axis is in Time



My application work in this ways. I got a database collect data from 20 sensors. Database holds Temperature and DateTime data/Records from sensors. So i would like to make it whenever i view the chart, it will plot a line chart one by one according to the temperature and timestamp(DateTime). Which mean my X axis is a colleborate time on that particular date. Anyone did this before or advice ? Thanks.

I already design a in the way that the line chart will plot base on both dropdownlist, Sensor ID and Date. So it will work like whenever i select a Date or ID it will read the records from database table temperature.

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>      

Line Divider i n Column chart in SSRS 2008

Hi,  Any one pls tel me how to do the single line divider in Column chart in SSRS 2008 example: --------- |               | |     20      | ---------- |       100 | |               | -------------------------------   i want to show the above example. Thanks in advance Regards, Abdul2010

Display name of months on x-axis in a chart

Could you please let me know if there is any expression which can be used to display the months on x-axis of the column chart. I've tried playing with the Axis option trying to change the interval type to "months" but it is not giving the result. Thank you.

Pie chart - overlapping labels?

I have a pie chart that has overlapping labels. I want the labels to display text plus the value, which I have working. However, not all of the labels are outside of the pie chart area, and thus are overlapping. Also, how can I set the pie chart to take up more room within the chart itself?   Here's a URL to see my chart:  http://i34.tinypic.com/23kt0sw.jpg

X-axis labels missing: SSRS 2005

Hi, I have a single line chart in a list, with hourly intervals on the X-axis. The generated report has a number of charts displayed, one for each group in the list. For some charts the X-axis labels depicting the hour are shown for all intervals. For others, I do not see the label for the first and last interval. The intervals are spaced out enough and there is no reason why SSRS may choose to not show a label because of a space constraint. Any idea why some labels along the x-axis are missing? Thanks, Yash

dynamic min value in y-axis for line chart

How to set dynamic min value in y-axis for line chart in ssrs 2005 give me examples Table Test rid Percentage Reason1 98 Reason2 89 Reason3 87 Reason4 82 Reason5 91 Reason6 96 example: y-axis should start 80(if it is 70 it should start 70) by dynamically

Is there a way to specify that I do not want fractions for my interval on a chart axis ?

Using reporting services 2008 I have a bar chart which shows number of employees by department. When the number of employee is small, I get fractions on the Y axis like 0, 0.25, 0.5, 0.75, 1, 1.25, 1.5, 1.75, 2 I know that I can manually set the interval to 1 which solves the problem but I also have the same problem with bigger numbers (I also have the scale breaks enabled) For example when I have 40, 44 and 66 in my dataset the Y axis is as follow: 39.6, 39.8, 40.0, 40.2, 43.6 (scale break), 65.6 (scale break), 66.1 This is not really what I expected... Is there any way to get a better behavior ? Thanks Paul

How to align data in Chart legend in SSRS 2008?

Hi,I have created a chart of type 3D pie.  I put a String field for Category and Sum(numeric field) for Data.I wanted to show the legend as Category field and Data field and it's displaying as i set.Now how to make alignment of Data in legend, so that my numeric fields should align Right and String field should align Left.  I can make whole legend alignment but I want to make only the numeric field in the legend to align Right.Is it possible or there any work around?Please let me know.
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