Creating Line Chart Expession Based Y-Axis Scale Values

Feb 28, 2008



Hello,
I need to know what means are available to change the Minimum and Maximum Y-Axis scale values rather than leave them simply as they are in the properties.
Right now whatever min/max values I enter into the scale for the Y-Axis are unchangeable.
I need to be able to change the min/max scale values based on the value of the data at run time.

Any help is appreciated.

Thanks.

View 6 Replies


ADVERTISEMENT

Colouring The Chart Plot Area Based On X-axis Scale

May 3, 2007



Hi,



I have a report based on a line chart.

The values on X-axis are scaled from -100 to +100. I want to colour the band from -100 to 0 with red colour and that from 0 to +100 in green colour, and i want to provide legend for these bands/sections. How can i do this?

A prompt response would be really appreciated



Thanks a lot!!



Simranjeev

View 1 Replies View Related

Chart Problem: Multiple Values To Y-axis For The The Same X-axis Value

Jan 14, 2007

I have a simple-column chart and in the x-axis I put the date values and in the y-axis the sale price values.

The chart works perfectly in the case when there is only one sale price for the same date. But, when the price changes during the same day, then there is problem. In the following example

x y

1/1/2007 6.25

2/1/2007 7

2/1/2007 4

3/1/2007 8

the chart will have three columns and in the date 2/1/2007 will display the min or max of the two values. What I need is to represent all the values i.e. the chart must have four columns , as much as the rows of the dataset

Is it possible?

View 1 Replies View Related

Chart-simple Line X-axis

May 29, 2007

How is it possible to have the values on the chart x-axis to be shown vertically rather than horizantal?
Thanks

View 3 Replies View Related

Reporting Services :: Line And Bar Chart With One Scale

Nov 12, 2015

Is there a possibility in SSRS to have  One stacked bar of cumulative sum of different ID's and and Line Chart at left hand of the Bar which will show the Progress as soon as the ID turn to Competed status.

I have been trying to do this , however there is huge problem of scaling:

The line should be finished at all the completed ID's SUM which is the lowest stack of the Bar.

However , the bar gets stretched to all of the space.

I have tried to place it into Tab lix, But it doesn't work.

View 3 Replies View Related

Reporting Services :: Date Labels On X Axis In SSRS Line Chart

Jul 27, 2015

What is the best optimised options to display the date labels with bi-weekly intervals starting date Date from one month to three months future from the current date?

As per above requirements, I have built the below line graph query and graph, currently it only displays the date labels as per data but I need to display date labels with bi-weekly intervals starting date from one month to three months future from the current date. Also another issue found, if there are few more date labels then does not show all labels on horizontal axis.

Select
/* Set Week End date as Sunday */
DATEADD(DAY, 7 - DATEPART(WEEKDAY, t.TaskBaseline0FinishDate), CAST(t.TaskBaseline0FinishDate
+1 AS DATE)) as[WeekEnd]
,count(t.TaskBaseline0FinishDate) as Baseline
,count(t.TaskFinishDate) as Finish

[Code] .....

View 3 Replies View Related

Selecting Numeric Or Time-scale Values On Chart Yields Duplicate Months

Feb 15, 2008



I have a line chart which works great except when the x axis displays duplicate months. I have tried format codes of MM-YYYY and MMM and have the "numeric or time-scale values" checkbox checked. The data displays fine but the X axis in the case of the MMM format code displays as:

Sep Oct Oct Nov Nov

leaving the user to wonder where exactly does October and November start...

I've googled around but don't see off-hand what I am doing wrong. I am display 3 simultaneous lines if that matters...

Thanks!
Craig

View 4 Replies View Related

Zero Values On A Line Chart

Jan 27, 2007

am using a line chart to display series of results over time - data is got from and AnalysisServices cube.

problem is that sometimes there is no value for the result - and the chart doesnt display that as zero

e.g. with the following data

week 1 10 items

week 2 12 items

week 3 14 items

week 4 8 items

week 6 12 items

the chart will join the week 4 result of 8 items directly to the week 6 result of 12 items

is there anyway of changing this so the line goes from 8 items on week 4 to ZERO items on week 5 and then 12 items on week 6 ???

View 1 Replies View Related

Display Null Values As 0 On Line Chart

May 16, 2008

I have a report I'm writing and have got a problem that has stumped me.



The data the report is based in is in this format:



Date Type

1/1/08 A

1/3/08 B

3/1/08 C

3/5/08 B

3/10/08 A

3/12/08 C

3/20/08 A





Management wants a report showing a line chart that summarizes the data by Month and by Type. So, there are 2 series depending on the Type and data values are based on the count of each Type. So, in the example above the x-axis group would be month, the values would be count(Type) and there would be 2 series €“ Series 1. A, B and Series 2. C



I€™ve defined the x-axis to be Month(Fields!DateOccured.Value). However, they want the x-axis to show every month for the entire year not just what is in the database. So, I defined the x-axis to have a scale of 1 to 12 and the major interval is set to 1. This displays 1 through 12 on the x-axis.



The problem is when there is no data (null) for a particular month. Instead of showing 0, the line chart does not plot anything and the line is drawn to the next displayed point. So, for example on the data above the line chart would plot:

January

Series 1 €“ Qty. 2 Series 2 €“ Qty. 0

February

Null

March

Series 1 €“ Qty. 3 Series 2 €“ Qty. 2



The line chart would draw a line from January to March skipping February. I need to display the null values as 0 and not null indicating no occurrences for the month rather than no data present.



Thanks!


View 11 Replies View Related

Line Chart With Breaks For Missing Values

Dec 13, 2007

I can't figure out how to get my line chart to break when there isn't a value. For example, I have a trend line over 4 time periods. The 3rd time period is missing a value. Instead of the line ending at the 2nd period and picking up again at the 4th time period, it's connecting the line 2nd to the 4th period. I'd like it to break and for there to be no line appearing in the 3rd period. I bet that's as clear as mud, but let me know if you have any questions.

Thanks!
sash

View 1 Replies View Related

How Change The Scale Of X Axis?

Mar 29, 2007

Hi, how do I change the scale of x axis to a larger time scale than the data ?

Data is in quarters and I want that to be displayed in a line graph, but I want the labels to show hours

(it becomes messy otherwise when showing several days)



Thank You,

Regards

Göran



View 4 Replies View Related

Minimum Scale Of Y-axis Ignored When Using Negative Value

May 21, 2007

I want to display a chart with a minimum y-axis of -10%. When use the value -0.10 the result is a minimum of -100%. Is this a bug?

-Jeroen

View 2 Replies View Related

Creating A Chart Based On Data In A Matrix

Jun 27, 2007

I am using a matrix to display current and historical financial data. To do this, I am using 5 different datasets. Each dataset contains 1 row of data for a specific year for a specific account.



Now that problem I am having is displaying this data in a chart. When I create a new chart, it asks which dataset I would like to use. I do not want to use any specific dataset, I want to get chart's data from the matrix. Is this possible?

View 8 Replies View Related

Power Pivot :: Change Y Axis Scale In PowerView

Aug 20, 2015

I created the below graph in PowerView. The Y axis shows values in % but I want to change this to millions. How do I do this?The Y axis value is the result of a calculation that is formatted as currency in the PowerPivot Manager.

View 2 Replies View Related

SQL Server 2008 :: Creating Multiple Charts Based Off Of Main Chart

Jun 4, 2015

I have this main chart setup. It pulls data from a query based on the selected parameters.

I want to create multiple charts for every catagory in the result set.

On the main chart there is a catagory called "Missing".

I want a chart for this category to display when the main chart is loaded. So below the main chart it would show a chart for each of the categories on the main chart.

Basically this report returns information on a certain part number displaying its problem types. Then I want it to create other charts for each problem type displaying the problem sub-types.

View 1 Replies View Related

Chart X-axis Y-axis

Jan 17, 2007

I'm trying to convert an old chart to Reporting Services.
We have used the same dataset for years, it is very very simple. But it seems to me that Reporting Services can't deal with this simple dataset.

My question is: How can I get create a line chart using this dataset.

The data set consists of 1 row with 96 columns (a day divided into 96 sets of 15 minutes). Each column records how many events occurs within the 15 minutes. Along the x axis I would like to display a vertical line every 4 hours. The y axis should be numbered 0 to the highest value in the results.


I could not make this dataset any more simple than it is. But Reporting Services just chokes on this.

Here is a sample of the dataset :
1 2 0 4 5 6 7 8 9 10... 96

View 1 Replies View Related

Bar Chart Scale

Sep 7, 2007



Can you have different scales on a bar chart. I want to chart sales and quantity. Oracle lets you label the top of the bar chart as money and the bottom as quantity.

I am dividing my sales by one million and quantity by one thousand to make them similar in size on the same chart. I am using the sum of the sales/1000000 as a point label. Is there any way to limit the number of decimal places displayed. Currently it is displaying something like 1.94889312043; 1.95M would be better.

Thank you.

View 2 Replies View Related

Chart Axis

Oct 17, 2007

I created a graph which retrieves value from database.And currently,my axis is in ranged 0-10.But i have a doubt that my value in will exceed my maximum y-axis value 10..My question is, could it be possible that i make my y-axis dynamic??Thanks!!

View 5 Replies View Related

Reporting Services :: How To Show Bar And Line Chart In Same Chart

Oct 21, 2015

I need to create a chart with the following features

1) Bar chart that has data for 3 years (3 series)
2) Line chart that has the same data as per the above points on the bar chart but this is a running total. (3 series)
3) These data points are for the 12 months
4) there should be a secondary axis for the cumulative one

Can I create this using the same data set?

View 6 Replies View Related

Multiple Value On Y Axis In Chart?

Sep 5, 2007

Friends, I would like to put employee name and type of leave on the y-axis and on the x-axis the date, so that users can select the date start and end and employee/employees and see the chart or leaves.
But how to do that?
My fields are: Name, LeaveDescription and Date.
The data with me is for each employee, for each date, leave codes are there.

View 4 Replies View Related

IS It Possible To Scale Chart In SQL Server 2000

Mar 30, 2007

Hi



I need to scale barchar or any other chart in sql server 2000

i need to know the possiblity of this in SQl 2000



Regards

View 2 Replies View Related

Add Additional Right Scale On Chart Report

Jan 21, 2007

Hi there,

I have a case. I have 3 numeric fields and 1 category field to be displayed on bar chart reports. the problem is 2 of the 3 numeric fields have significant different scale value. so I need to add additonal scale at the right side of bar chart to represent 1 numeric fields + the 2 other numeric fields at the left side scale (Y). Please advice. Thanks.

R'gards

Toni

View 1 Replies View Related

Chaging The Min And Max Scale Of A Chart At Run Time

Aug 8, 2006

I have a stored procedure which will bring me back the Min, Max and Mean of different result sets. What I want to do with the Y-Axis is set the Min scale value of the chart to be Min -%5 and the Max scale value to be Max + 5%.

Is there a way to change the Y-Axis values at report run time without spitting my own RDL?

View 4 Replies View Related

Reporting Services :: Draw Trend Line For SSRS Line Chart 2005

May 4, 2012

I need the Trend line for the following data in Line chart they are the following data. The following are the graph are my output and i need the trend line for these Key_gap value.

This is the link [URL] ....

I need the same trend line for the Bar-Chart in SSRS 2005.

View 5 Replies View Related

Chart Axis, How To Add A Prefix To A Label ?

Jun 5, 2008

I'm just getting into creating charts and one I'm working on could realy do with a prefix on its axis label, the symbol '£'.

I honestly have no idea how to do this and what syntax to use, can anyone help ?.

Also as the label could do with having a thousands seperator as well but as you can tell I'd have no idea how to do this either.

Thanks.

View 1 Replies View Related

Chart Properties - Date On X Axis

Nov 27, 2007



Hi!
In SSRS2005 I made an chart,
but on x-axis I only want date-part (if possible ISO-format yyyy-mm-dd).

The resulting chart shows date AND time-part. How to avoid this?

thanks.

View 5 Replies View Related

Chart Y-axis Intervals Not Using Formula?

Jul 17, 2007

i put the formula day(Parameters!Parameter1.Value) into my y-axis's major gridlines interval value, and it doesn't obey the value i put in.

is this a bug or another "feature"?



when i just type in "31" is works as expected.



is there a work around for this?

View 4 Replies View Related

Only Dates In X-Axis Of Chart --Urgent

Sep 30, 2007



Hi

I have a report where i am using line chart with date column for grouping.
For X axis i have choosen the "NUmeric or Timescale Values". In the Chart the dates are displayed in this format 1/1/2007 12:00:00 AM . I don't want Time part to be shown

If possible i want it to be shown as 1-Jan. The Chart should display Point even when there is no record returned from the query.

Say DATE Column

Date AMOUNT
1/1/2007 12:00:00 AM 10
1/3/2007 12:00:00 AM 20
1/4/2007 12:00:00 AM 30

Now the Chart should plot from 1/1/2007 to 1/4/2007 including 1/2/2007

Any help on this will be appreciated

Thanks
Smitha

View 1 Replies View Related

Format Numbers On Chart Y Axis

Jan 2, 2007

Hi!

How can I format number on chart's y axis? I wanto to show 1.000 instead of 1000.

Thank you!

View 1 Replies View Related

Displaying A Trend Line (in Line Chart) In SSRS

Feb 7, 2007

We have a line graph which plots the actual data points (x,y), everything is working fine with this graph. Now we need to add a trend line to this existing graph after going thro. the articles we came to know that there is no direct option in SSRS to draw a trend line. So we need to calculate the trend values ourselves which we need to plot as atrend line. This trend line is similar to the trend line which comes in Excel chart, do anyone know how to calculate the trend values from the actual data points. We got through several formulas, but were not clear, have anyone tried out exactly the same, if so please help us out by providing an example to calculate the trend values.

View 1 Replies View Related

Pivot Chart Value Axis Scaling Question

Jul 23, 2005

I have a pivot chart that displays 3 data series.Series 1 values range from 17 to 106.Series 2 values range from 1 to 18.Series 3 values range from 0 to 1.When I display all three series on the chart, the value axis labels run from1 to 120 with major unit lines at intervals of 20.When I remove Series 1, the chart automatically adjusts itself and thevalue axis labels run from 1 to 20 with lines at intervals of 2, thusnicely accommodating the value ranges of Series 1 and Series 2.All this is fine. But when I remove Series 2, leaving only Series 3,the labels run from 1 to 1.2 with interval spacing of .2. Since thesevalues are counts, it makes little sense to show decimal values.Can anyone provide advice on how to keep these axis labels fromshowing decimal values, if a user removes Series 1 and Series 2?Thanks.- Bob

View 2 Replies View Related

Foramtting Chart Axis Colour Using Expression

Sep 8, 2006

I have a chart on a report that shows value in £ on the Y Axis. The values can be both positive and negative. I would like to have the negative labels to show in red and the positive in black. What is the expression syntax to achieve this? i know it will be an IIF statement, but what is the syntax to show the Y Axis label as <0?



eg if i was doing this for a field it would be iif(Field!Fieldname.value <0, "RED","BLACK") but what would i replace the FIELD!Fieldname.vaue with so the expression would change the Y Axis label.


Thanks in advance for any help



Dave Munro

View 1 Replies View Related

Report Builder - Format Chart Y Axis

Oct 27, 2005

Is changing the display format of the Y axis of a column chart supported in the Sept CTP or is it going to be supported in the official release?  For example I have built a report model with the numeric sales values set as 'C' for currency and have created a simple bar chart with year on the category axis and sales on the Y axis.  The problem is that the Y axis displays as a general number (10000000) and would like to display it as a currency ($10,000,000). I can't for the life of me figure out how to display the Y axis as currency in Report Builder.

View 2 Replies View Related







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