Showing posts with label bar. Show all posts
Showing posts with label bar. Show all posts

Friday, March 23, 2012

Point Lables for the Bar chart

Hi friends,

We are using SQL Server 2005 Reporting Services for our project.In one of our reports we are showing horizontal bar chart along with the values in front the bar. for eg Graph is Asset Class VS Percentage values. We have Equity , FI , Cash , Others as Asset Class along with percentage values. In graph we are displaying Equity first. When we excecute report I can see the percentage values for FI , cash , others but not for equity.

If I change the order and get equity last then I cant see the value of Others . In short the bar which is coming first is not showing value in front of it. So where I am making mistake ?

can any one help me out ?

regards

sandy.....

As you have already discovered, this is discussed in the following thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=208591&SiteID=1

-- Robert

point labels bar charts

It looks to me like you can only place point labels outside of the chart when
using pie charts. Can someone verify this for me or let me know what I am
doing wrong? Chart type is column, delselected Auto and chose right but the
label is still in the middle of the column area.
Also, we would like to be able to control overlaping labels. I saw a
posting that this is not supported - is this true and will it be supported in
the next version?
Thanks!If you check "Auto" for the datapoint label position, then the labels should
never overlap (unless you have a stacked column/bar chart where it can still
happen).
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"debra doty" <debradoty@.discussions.microsoft.com> wrote in message
news:395CDF6E-AC41-48BE-83C2-1112FABFC60F@.microsoft.com...
> It looks to me like you can only place point labels outside of the chart
when
> using pie charts. Can someone verify this for me or let me know what I am
> doing wrong? Chart type is column, delselected Auto and chose right but
the
> label is still in the middle of the column area.
> Also, we would like to be able to control overlaping labels. I saw a
> posting that this is not supported - is this true and will it be supported
in
> the next version?
> Thanks!|||But they do overlap. Mainly we are having a problem with lines on bar
charts. Point labels on the lines are overlapping point labels on the bars
as well as other lines. Auto is selected.
"Robert Bruckner [MSFT]" wrote:
> If you check "Auto" for the datapoint label position, then the labels should
> never overlap (unless you have a stacked column/bar chart where it can still
> happen).
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "debra doty" <debradoty@.discussions.microsoft.com> wrote in message
> news:395CDF6E-AC41-48BE-83C2-1112FABFC60F@.microsoft.com...
> > It looks to me like you can only place point labels outside of the chart
> when
> > using pie charts. Can someone verify this for me or let me know what I am
> > doing wrong? Chart type is column, delselected Auto and chose right but
> the
> > label is still in the middle of the column area.
> >
> > Also, we would like to be able to control overlaping labels. I saw a
> > posting that this is not supported - is this true and will it be supported
> in
> > the next version?
> >
> > Thanks!
>
>|||I just double checked the behavior to be sure I was stating it clearly. When
auto is selected, the line point labels overlap the bar point labels. When
auto is not selected, we don't get the arrow pointing to the line the label
is for. This is a problem for lines that are close to each other. Because
the labels can't appear outside of the chart, part of the text is chopped
off.
If we could set the line point labels to display outside of the graph, we
wouldn't have this problem. I guess I am asking to put this on the wish list.
"debra doty" wrote:
> But they do overlap. Mainly we are having a problem with lines on bar
> charts. Point labels on the lines are overlapping point labels on the bars
> as well as other lines. Auto is selected.
> "Robert Bruckner [MSFT]" wrote:
> > If you check "Auto" for the datapoint label position, then the labels should
> > never overlap (unless you have a stacked column/bar chart where it can still
> > happen).
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> > "debra doty" <debradoty@.discussions.microsoft.com> wrote in message
> > news:395CDF6E-AC41-48BE-83C2-1112FABFC60F@.microsoft.com...
> > > It looks to me like you can only place point labels outside of the chart
> > when
> > > using pie charts. Can someone verify this for me or let me know what I am
> > > doing wrong? Chart type is column, delselected Auto and chose right but
> > the
> > > label is still in the middle of the column area.
> > >
> > > Also, we would like to be able to control overlaping labels. I saw a
> > > posting that this is not supported - is this true and will it be supported
> > in
> > > the next version?
> > >
> > > Thanks!
> >
> >
> >|||If we set all of the point labels (for all lines and all bars) to Auto, they
do not overlap. But, the numbers are all strewn over the report so no human
being could possibly read it.
We should be able to tell some data values to move their point labels
automatically and set other values. Having the line point lables outside of
the chart would also solve our problem.
"debra doty" wrote:
> But they do overlap. Mainly we are having a problem with lines on bar
> charts. Point labels on the lines are overlapping point labels on the bars
> as well as other lines. Auto is selected.
> "Robert Bruckner [MSFT]" wrote:
> > If you check "Auto" for the datapoint label position, then the labels should
> > never overlap (unless you have a stacked column/bar chart where it can still
> > happen).
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> > "debra doty" <debradoty@.discussions.microsoft.com> wrote in message
> > news:395CDF6E-AC41-48BE-83C2-1112FABFC60F@.microsoft.com...
> > > It looks to me like you can only place point labels outside of the chart
> > when
> > > using pie charts. Can someone verify this for me or let me know what I am
> > > doing wrong? Chart type is column, delselected Auto and chose right but
> > the
> > > label is still in the middle of the column area.
> > >
> > > Also, we would like to be able to control overlaping labels. I saw a
> > > posting that this is not supported - is this true and will it be supported
> > in
> > > the next version?
> > >
> > > Thanks!
> >
> >
> >

Point Label not displaying on a bar chart

I am using Reporting Services 2000.

I have one bar chart that has two values and one group. Everything works fine except when two values are returned, then the point label for the top bar never displays. Example

A (has 2 bars)

B (has 2 bars)

Only the top bar for A will not display the point label. I can change the sort order and make A appear first and then the top bar for B doesn't have the point label now. When I change the order of the values, the top bar that didn't have the label has one because it is second from the top, but the new top bar doesn't. Is this a bug or am I doing something wrong. Thanks.

Try to turn on margins for the x-axis.

-- Robert

|||

Hi Robert,

Thank you so much , your solution is working

thx again

ragards,

-sandyee

Point Label not displaying on a bar chart

I am using Reporting Services 2000.

I have one bar chart that has two values and one group. Everything works fine except when two values are returned, then the point label for the top bar never displays. Example

A (has 2 bars)

B (has 2 bars)

Only the top bar for A will not display the point label. I can change the sort order and make A appear first and then the top bar for B doesn't have the point label now. When I change the order of the values, the top bar that didn't have the label has one because it is second from the top, but the new top bar doesn't. Is this a bug or am I doing something wrong. Thanks.

Try to turn on margins for the x-axis.

-- Robert

|||

Hi Robert,

Thank you so much , your solution is working

thx again

ragards,

-sandyee

Friday, March 9, 2012

plot data as line option

I have a bar chart that compares data across two dates. These dates are
passed in as parameters. Currently these are displayed as bars but i'd like
the first to be shown as a line. The query groups by date.I assume you have two data series in the chart. Right-click on the chart to
open the chart properties dialog. In the chart properties dialog box, click
the Data tab. In the Values list, click the one data series you want to show
as line, and then click Edit. In the Edit Chart Value dialog box, click the
Appearance tab. Click to select the "Plot data as line" check box.
You may also be interested in a related KB article:
http://support.microsoft.com/kb/842422
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Melissag" <Melissag@.discussions.microsoft.com> wrote in message
news:1DDFCCAE-3BD6-4BBA-AF10-CE2201A66BD0@.microsoft.com...
>I have a bar chart that compares data across two dates. These dates are
> passed in as parameters. Currently these are displayed as bars but i'd
> like
> the first to be shown as a line. The query groups by date.|||Hi Robert,
At the moment i have a single data series: date derived from a group by date
in the query. How would i go about created two data series one for each date?
Thanks,
Melissa.
"Robert Bruckner [MSFT]" wrote:
> I assume you have two data series in the chart. Right-click on the chart to
> open the chart properties dialog. In the chart properties dialog box, click
> the Data tab. In the Values list, click the one data series you want to show
> as line, and then click Edit. In the Edit Chart Value dialog box, click the
> Appearance tab. Click to select the "Plot data as line" check box.
> You may also be interested in a related KB article:
> http://support.microsoft.com/kb/842422
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Melissag" <Melissag@.discussions.microsoft.com> wrote in message
> news:1DDFCCAE-3BD6-4BBA-AF10-CE2201A66BD0@.microsoft.com...
> >I have a bar chart that compares data across two dates. These dates are
> > passed in as parameters. Currently these are displayed as bars but i'd
> > like
> > the first to be shown as a line. The query groups by date.
>
>