Charts and Graphs Question

I have a chart that has dates list on the x axis in a horizontal fashion. I
would like to change them to be vertical. Can anyone tell me how todo this'
Thanks,Andy,
I don't think you can set it, it seems to be automatic. If the dates
don't fit horizontally, it turns them for you.
The only thing you can affect is the data labels inside the chart area.
Chris
Andy Jones wrote:
> I have a chart that has dates list on the x axis in a horizontal
> fashion. I would like to change them to be vertical. Can anyone tell
> me how todo this'
> Thanks,

Chart Y-axis Values Problem

I created a chart using some calculated fields, the calculations are working
correctly (I manually checked the math), but the Y axis values are way off.
The highest field value generated was 18,544 but the scale on the chart was
showing 500,000 with the bar reaching nearly to the top. I could understand
if the scale was just off and the bar stopped at the correct position, but
not only is the scale off, the bar doesn't correctly represent the value
either. Because this report will be used for several customers I can't
manually set a limit for the Y-axis. I turned off the labels for the Y-axis
so that I can use the chart, but I would prefer being able to see the labels.
I have installed SP1. Any help would be appreciated.
JoeHi, you can convert the scale of your chart in a expression in the RDL; try
it.
John Bocachica
Colombia
"JHoward" <JHoward@.discussions.microsoft.com> wrote in message
news:78D0BEDF-A212-4B07-9641-9A1615E6168F@.microsoft.com...
>I created a chart using some calculated fields, the calculations are
>working
> correctly (I manually checked the math), but the Y axis values are way
> off.
> The highest field value generated was 18,544 but the scale on the chart
> was
> showing 500,000 with the bar reaching nearly to the top. I could
> understand
> if the scale was just off and the bar stopped at the correct position, but
> not only is the scale off, the bar doesn't correctly represent the value
> either. Because this report will be used for several customers I can't
> manually set a limit for the Y-axis. I turned off the labels for the
> Y-axis
> so that I can use the chart, but I would prefer being able to see the
> labels.
> I have installed SP1. Any help would be appreciated.
> Joe|||Note: expression-based min/max/intervals will only be available on RS2005.
Joe, can you post a simplified report which runs e.g. based on Northwind
data and reproduces the issue?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"John Bocachica (Colombia)" <jbocachica@.gmail.com> wrote in message
news:e%23FQGGl%23EHA.1084@.tk2msftngp13.phx.gbl...
> Hi, you can convert the scale of your chart in a expression in the RDL;
try
> it.
> John Bocachica
> Colombia
> "JHoward" <JHoward@.discussions.microsoft.com> wrote in message
> news:78D0BEDF-A212-4B07-9641-9A1615E6168F@.microsoft.com...
> >I created a chart using some calculated fields, the calculations are
> >working
> > correctly (I manually checked the math), but the Y axis values are way
> > off.
> > The highest field value generated was 18,544 but the scale on the chart
> > was
> > showing 500,000 with the bar reaching nearly to the top. I could
> > understand
> > if the scale was just off and the bar stopped at the correct position,
but
> > not only is the scale off, the bar doesn't correctly represent the value
> > either. Because this report will be used for several customers I can't
> > manually set a limit for the Y-axis. I turned off the labels for the
> > Y-axis
> > so that I can use the chart, but I would prefer being able to see the
> > labels.
> > I have installed SP1. Any help would be appreciated.
> >
> > Joe
>

Chart problem

I am displaying a chart in crystal report. In this chart/graph on the vertical data axis i have values in the format like 0.00. Now I want to display this value in the format 0:00, i.e. I want to replace the period(.) with a colon.

I am not getting any solution for this. Also I have a field label on the top of the graph which is formula. In this also I have the same problem.

I can get a colon in the Time format but it is disturbing the number system of the graph.

Need a solution.I have a similar problem at the moment; my dates on the horizontal axis are in the standard DD/MM/YYYY format, whereas I need DD.MM.YYYY. I don't think Crystal Graphing tool is powerful enough to do this, but I did find that I could make it appear this way by changing my computer's regional settings.

Hope this is of some help to you.|||Yes, even I think that crystal is not capable of such a thing.
Thanks for your input anyway.

Chart Problem

My y axis of bar chart does not show values when there is more data in table. Is there any way out .please help me
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.Right click on the chart control and go to chart
properties , then go to Y Axis tab and remove all values
under scale.
Hope this helps.
>--Original Message--
>My y axis of bar chart does not show values when there is
more data in table. Is there any way out .please help me
>--
>Posted using Wimdows.net NntpNews Component -
>Post Made from http://www.SqlJunkies.com/newsgroups Our
newsgroup engine supports Post Alerts, Ratings, and
Searching.
>.
>

Chart Problem

I want to display numeric value like 1,2,3,4,5 on X'Axis in Column Graph how to do this?I have GroupName on X'Axis.but i do not want to show id of tht GroupName on X'Axis.I want to show statuc numeric value in SQl server 2005 SSRS.
Can anyone help Me?
Thanks
Care Career
From http://www.developmentnow.com/g/115_2004_12_0_6_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comHi
Turn off your axis labels and create a table item to display what you
need. Look at my reply in this post
http://groups.google.com.au/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/e9c478240484b44a/ad757ca86965ed0e?hl=en&lnk=st&q=#ad757ca86965ed0e
Cheers
Shai
On Nov 19, 10:18 pm, Care Career<vertex.vibha.gro...@.hotmail.com>
wrote:
> I want to display numeric value like 1,2,3,4,5 on X'Axis in Column Graph how to do this?I have GroupName on X'Axis.but i do not want to show id of tht GroupName on X'Axis.I want to show statuc numeric value in SQl server 2005 SSRS.
> Can anyone help Me?
> Thanks
> Care Career
> Fromhttp://www.developmentnow.com/g/115_2004_12_0_6_0/sql-server-reportin...
> Posted via DevelopmentNow.com Groupshttp://www.developmentnow.com

chart label mapping to strings

How can I convert chart axis labels to strings. For example instead of
showing 1, 2, 3.. on x axis, how can I show gold, silver etc? Thanks.You can either add a CASE statement to the SQL query and use that for
your label field, or you can add a calculated field to the dataset.
-Josh
bhanoji wrote:
> How can I convert chart axis labels to strings. For example instead of
> showing 1, 2, 3.. on x axis, how can I show gold, silver etc? Thanks.|||I can't create a case statement for label field because if the value is 1 I
say gold and 2 will be silver etc. However if the data is 1.5 I can't map
that to a string. Thanks.
"Josh" wrote:
> You can either add a CASE statement to the SQL query and use that for
> your label field, or you can add a calculated field to the dataset.
> -Josh
> bhanoji wrote:
> > How can I convert chart axis labels to strings. For example instead of
> > showing 1, 2, 3.. on x axis, how can I show gold, silver etc? Thanks.
>|||What do you want it to display if the value is 1.5? Nothing? The actual
value?
-Josh
bhanoji wrote:
> I can't create a case statement for label field because if the value is 1 I
> say gold and 2 will be silver etc. However if the data is 1.5 I can't map
> that to a string. Thanks.
> "Josh" wrote:
> >
> > You can either add a CASE statement to the SQL query and use that for
> > your label field, or you can add a calculated field to the dataset.
> >
> > -Josh
> >
> > bhanoji wrote:
> > > How can I convert chart axis labels to strings. For example instead of
> > > showing 1, 2, 3.. on x axis, how can I show gold, silver etc? Thanks.
> >
> >|||I have the following data
City Speakers
A 8
B 15
C 3
D 7
The graph is showing A, B, C, D on X axis and 5, 10, 15 on Y axis as major
interval is 5. How can I show Bronze, Silver, Gold instead of Y axis labels
5, 10, 15.
Thanks Josh.
"Josh" wrote:
> What do you want it to display if the value is 1.5? Nothing? The actual
> value?
> -Josh
>
> bhanoji wrote:
> > I can't create a case statement for label field because if the value is 1 I
> > say gold and 2 will be silver etc. However if the data is 1.5 I can't map
> > that to a string. Thanks.
> >
> > "Josh" wrote:
> >
> > >
> > > You can either add a CASE statement to the SQL query and use that for
> > > your label field, or you can add a calculated field to the dataset.
> > >
> > > -Josh
> > >
> > > bhanoji wrote:
> > > > How can I convert chart axis labels to strings. For example instead of
> > > > showing 1, 2, 3.. on x axis, how can I show gold, silver etc? Thanks.
> > >
> > >
>|||I found another thread that discusses this. Check it out at:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/1a7ac279edf86082/c8207d4c72f15e26?lnk=st&q=%22values+on+y-axis%22&rnum=1#c8207d4c72f15e26
-Josh
bhanoji wrote:
> I have the following data
> City Speakers
> A 8
> B 15
> C 3
> D 7
> The graph is showing A, B, C, D on X axis and 5, 10, 15 on Y axis as major
> interval is 5. How can I show Bronze, Silver, Gold instead of Y axis labels
> 5, 10, 15.
> Thanks Josh.
>
> "Josh" wrote:
> >
> > What do you want it to display if the value is 1.5? Nothing? The actual
> > value?
> >
> > -Josh
> >
> >
> > bhanoji wrote:
> > > I can't create a case statement for label field because if the value is 1 I
> > > say gold and 2 will be silver etc. However if the data is 1.5 I can't map
> > > that to a string. Thanks.
> > >
> > > "Josh" wrote:
> > >
> > > >
> > > > You can either add a CASE statement to the SQL query and use that for
> > > > your label field, or you can add a calculated field to the dataset.
> > > >
> > > > -Josh
> > > >
> > > > bhanoji wrote:
> > > > > How can I convert chart axis labels to strings. For example instead of
> > > > > showing 1, 2, 3.. on x axis, how can I show gold, silver etc? Thanks.
> > > >
> > > >
> >
> >|||In Y axis tab of the chart, I checked show label and tried to put an
expression in the format code box.
expression in formatcode does not work. expression
"=iif(fields!abc.value=10, "gold",
iif(fields!abc.value=20, "bronze", "silver"))" generates the following error
Report item expressions can only refer to fields within the current data
scope or,
if inside an aggregate, the specified data set scope. Thanks.
"Josh" wrote:
> I found another thread that discusses this. Check it out at:
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/1a7ac279edf86082/c8207d4c72f15e26?lnk=st&q=%22values+on+y-axis%22&rnum=1#c8207d4c72f15e26
> -Josh
>
> bhanoji wrote:
> > I have the following data
> > City Speakers
> > A 8
> > B 15
> > C 3
> > D 7
> >
> > The graph is showing A, B, C, D on X axis and 5, 10, 15 on Y axis as major
> > interval is 5. How can I show Bronze, Silver, Gold instead of Y axis labels
> > 5, 10, 15.
> >
> > Thanks Josh.
> >
> >
> >
> > "Josh" wrote:
> >
> > >
> > > What do you want it to display if the value is 1.5? Nothing? The actual
> > > value?
> > >
> > > -Josh
> > >
> > >
> > > bhanoji wrote:
> > > > I can't create a case statement for label field because if the value is 1 I
> > > > say gold and 2 will be silver etc. However if the data is 1.5 I can't map
> > > > that to a string. Thanks.
> > > >
> > > > "Josh" wrote:
> > > >
> > > > >
> > > > > You can either add a CASE statement to the SQL query and use that for
> > > > > your label field, or you can add a calculated field to the dataset.
> > > > >
> > > > > -Josh
> > > > >
> > > > > bhanoji wrote:
> > > > > > How can I convert chart axis labels to strings. For example instead of
> > > > > > showing 1, 2, 3.. on x axis, how can I show gold, silver etc? Thanks.
> > > > >
> > > > >
> > >
> > >
>

Chart Interlacing Colors

For a given axis I can select to enable interlaced colors.
How do I select what the second, interlacing color is?
It appears to always be gray.
This is not ideal for the custom colors we have selected.
Thank you in advance.
JerryThe interlacing color is automatically determined based on the chart's
backgroundcolor or plotarea color (if they are explicitly set).
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jerry Nixon" <jerrynixon@.gmail.com> wrote in message
news:36f558cf.0410111518.7670c91f@.posting.google.com...
> For a given axis I can select to enable interlaced colors.
> How do I select what the second, interlacing color is?
> It appears to always be gray.
> This is not ideal for the custom colors we have selected.
> Thank you in advance.
> Jerry

Chart in crystal

I want to put an asterik next to the numbers on the Group axes (i.e. the numbers on the X axis of the chart) or on the data values of the chart.
Any clues?Cant you use text object for this?|||Can't use text box since it is a dynamic chart and the positions of the data values and group axis values change at runtime.|||Couldn't you write a formula and use that in place of your datafield?

Something like

"*" + " " + {table.field} and then place that in your chart?

Don't quote me that this will work, but I like to take a stab at things to see if I can make them work.

Chart Gridline Question

Is there a way to make Y axis gridlines intervals change dynamically?
Basically increase/decrease base on numbers being graph.Not in rs2k don't know about rs2k5. I got round this by overlaying graphs
and hiding the ones i didn't want to see depending on how much data i got
out.
Greg
"Johnny C" <JohnnyC@.discussions.microsoft.com> wrote in message
news:DD600FE2-F167-4B8E-8126-693E57B31D0B@.microsoft.com...
> Is there a way to make Y axis gridlines intervals change dynamically?
> Basically increase/decrease base on numbers being graph.

Chart Category Labels

How would I angle my category labels along the x axis of a Stacked Column
Chart. I can set the colors and and styles, but how do I go about making the
label or text sit at a 45 degree angle instead of vertical? Is there an
expression to place on the label property for the categories?This is currently not supported. It is under consideration for inclusion in
a future release.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Clint Jennings" <ClintJennings@.discussions.microsoft.com> wrote in message
news:613CADD4-2F13-469B-A1BA-EE25A02EAB1F@.microsoft.com...
> How would I angle my category labels along the x axis of a Stacked Column
> Chart. I can set the colors and and styles, but how do I go about making
the
> label or text sit at a 45 degree angle instead of vertical? Is there an
> expression to place on the label property for the categories?
>|||Thanks Robert.:)
"Robert Bruckner [MSFT]" wrote:
> This is currently not supported. It is under consideration for inclusion in
> a future release.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Clint Jennings" <ClintJennings@.discussions.microsoft.com> wrote in message
> news:613CADD4-2F13-469B-A1BA-EE25A02EAB1F@.microsoft.com...
> > How would I angle my category labels along the x axis of a Stacked Column
> > Chart. I can set the colors and and styles, but how do I go about making
> the
> > label or text sit at a 45 degree angle instead of vertical? Is there an
> > expression to place on the label property for the categories?
> >
>
>

Chart Axis Scaling - labelling every 5 points

Hi,
I have alot of trend data to display on a chart. The x-axis is used for
dates. However not only dont I need to display all the labels but they
clutter the chart.
Is there a way of only displaying every 5th date?
I tried using the following expression for the label colour but it didnt
work:-
=Iif(RowNumber("OrderDetail") Mod 5, "Black", "White")
Many thanks in advance for any help,
Steve.Please see this related posting:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=05353b5e-f780-406c-9da8-cd4a26bc8e09&sloc=en-us
In your case you should set the major interval of the x-axis to 5 (i.e.
interval of 5 days)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"fisab" <fisab@.discussions.microsoft.com> wrote in message
news:AFEE1ACE-4CAD-4682-99BF-AD7872CAE024@.microsoft.com...
> Hi,
> I have alot of trend data to display on a chart. The x-axis is used for
> dates. However not only dont I need to display all the labels but they
> clutter the chart.
> Is there a way of only displaying every 5th date?
> I tried using the following expression for the label colour but it didnt
> work:-
> =Iif(RowNumber("OrderDetail") Mod 5, "Black", "White")
> Many thanks in advance for any help,
> Steve.
>|||Thanks. Appreciate the help.
"Robert Bruckner [MSFT]" wrote:
> Please see this related posting:
> http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=05353b5e-f780-406c-9da8-cd4a26bc8e09&sloc=en-us
> In your case you should set the major interval of the x-axis to 5 (i.e.
> interval of 5 days)
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "fisab" <fisab@.discussions.microsoft.com> wrote in message
> news:AFEE1ACE-4CAD-4682-99BF-AD7872CAE024@.microsoft.com...
> > Hi,
> > I have alot of trend data to display on a chart. The x-axis is used for
> > dates. However not only dont I need to display all the labels but they
> > clutter the chart.
> > Is there a way of only displaying every 5th date?
> > I tried using the following expression for the label colour but it didnt
> > work:-
> > =Iif(RowNumber("OrderDetail") Mod 5, "Black", "White")
> >
> > Many thanks in advance for any help,
> >
> > Steve.
> >
>
>

Chart Axis Labels

Is there a way to format numerics like this:
Instead of this:
10,000,000,000
9,000,000,000
8,000,000,000
I would like this:
10B
9B
8B
Or Instead of this:
2,000,000
1,500,000
1,000,000
500,000
I would like this:
2M
1.5M
500k
Is this possible with the charting object? I am quite familiar with
the formatting codes but have never run across something like this.
Thank you in advance for your help.Does anyone know is this is possible?

chart axis

Does anyone know how one can control/modify/overwrite standard X and Y axis
in chart control? I am even reconsidering rewriting the whole char component
since it is far from what is must look like.
Thanks,
--
Martin Kulov
http://www.codeattest.com/blogs/martin
MCAD Charter Member
MCSD.NET Early Achiever
MCSD> Does anyone know how one can control/modify/overwrite standard X and Y
> axis in chart control?
My problem is that when I have two data series the X axis is grouped with
values from both series and makes it unreadable. How can I create two
separate X axis that can read easily?
Thanks,
--
Martin Kulov
http://www.codeattest.com/blogs/martin
MCAD Charter Member
MCSD.NET Early Achiever
MCSD
"Martin Kulov" <kulov@.bezbokluk.abv.bg> wrote in message
news:e$K3zardFHA.1036@.tk2msftngp13.phx.gbl...
> Does anyone know how one can control/modify/overwrite standard X and Y
> axis in chart control? I am even reconsidering rewriting the whole char
> component since it is far from what is must look like.
> Thanks,
> --
> Martin Kulov
> http://www.codeattest.com/blogs/martin
> MCAD Charter Member
> MCSD.NET Early Achiever
> MCSD
>

Chart Axis

I have created a bar chart with percentages as the variables. The numbers on
the chart are correct, but the scale is incorrect. The scale adjusts to 100%
for all fields.
Anyone else encountered this problem?
--
TDWhen using percentages (e.g. format code P on the Y-axis), you can either
auto-scale the axis or you can specify an explicit min/max value. If you
specify an explicit max value (e.g. 120%), you have to specify it as 1.2
rather than 120
For percentages, 1 means 100%.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"TDahlin" <TDahlin@.discussions.microsoft.com> wrote in message
news:D87A2D0A-D607-4483-A3B4-484A07B2C5AC@.microsoft.com...
>I have created a bar chart with percentages as the variables. The numbers
>on
> the chart are correct, but the scale is incorrect. The scale adjusts to
> 100%
> for all fields.
> Anyone else encountered this problem?
> --
> TD

Chart - X Axis

Can the labels on the x axis be rotated so that they display vertically. The
user wants a report that shows the month-year like May-2005, but with the
text rotated 90 degrees.The text orientation is determined automatically based on the horizontal
space available.
If you show many months along the X-axis, the labels will most likely not
fit horizontally (in one line or two lines) and will therefore get rotated.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chip Kaufman" <Chip Kaufman@.discussions.microsoft.com> wrote in message
news:B0E10C60-07E2-416F-8487-122E2151BB1E@.microsoft.com...
> Can the labels on the x axis be rotated so that they display vertically.
> The
> user wants a report that shows the month-year like May-2005, but with the
> text rotated 90 degrees.

Chart

Hi everyone,
I am currently using SSRS 2000. I have a chart that shows everything that we have shipped by specific part number. The Y axis displays the quantity and X axis shows the date. Well, the X axis I grouped it by year then by month, so it can display Jan 04, Dec 05, Mar 07, etc. but all I get is the year. How can I format it, or do so it can display that format??

Thanks ahead of time,
Abner

try this expression

=MonthName(Month(Fields!FeildName.Value),true)& " " & Year(Fields!Fieldname.Value)

|||

Thank you very much, works like a charm.

Abner