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 on Pie chart

I have a pie chart and have tried every option I could find on the Data tab for the point labels. They bunch up all over the place. What am I missing?

Does Dundas do this better?

Jerry

What do you mean "they bunch up all over the place" ? Have you tried an exploded Pie chart?

Edit: Also, on the data tab, click edit on your value. On the point labels tab, you can change the position and font size of the labels.

|||

Yes I have tried exploded pie charts.

By bunch up I mean that the labels overlap one another and are completly un-readable. This happens particularily with the sections that are small pieces of the pie.

|||

Adam Tappis could let you know if Dundas handles it better. I know he uses it.

By the way, SQL 2008 will come packaged with Dundas technology.

|||

Have you made sure that the point labels are outside the Pie graph rather than inside it?

http://msdn2.microsoft.com/en-us/library/ms156263.aspx

Also when I want to maximise space I choose the donut instead of pie

Cheers

Mark

point labels on charts

How can I get the point labes on a chart to appear inside the bar.Data point labels have two modes:
* automatic (checkbox on the data point label tab) - this will move labels
around so that they don't overlap
* manual (uncheck auto and use the 9 little buttons below it to determine
the label position)
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"steve" <steve@.discussions.microsoft.com> wrote in message
news:1997458C-5597-4680-A81F-9FCE96E04672@.microsoft.com...
> How can I get the point labes on a chart to appear inside the bar.|||I tried that and the labels are always outside the bar. I don't understand
where the 9 buttons are supposed to place the text.
"Robert Bruckner [MSFT]" wrote:
> Data point labels have two modes:
> * automatic (checkbox on the data point label tab) - this will move labels
> around so that they don't overlap
> * manual (uncheck auto and use the 9 little buttons below it to determine
> the label position)
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "steve" <steve@.discussions.microsoft.com> wrote in message
> news:1997458C-5597-4680-A81F-9FCE96E04672@.microsoft.com...
> > How can I get the point labes on a chart to appear inside the bar.
>
>|||The 9 buttons represent the label position as follows: top-left,
top-centered, top-right, middle-left, middle-centered, middle-right,
bottom-left, bottom-centered, bottom-right. Just try it.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:5A832C53-84F9-461E-83F1-36DCF8B12187@.microsoft.com...
>I tried that and the labels are always outside the bar. I don't understand
> where the 9 buttons are supposed to place the text.
> "Robert Bruckner [MSFT]" wrote:
>> Data point labels have two modes:
>> * automatic (checkbox on the data point label tab) - this will move
>> labels
>> around so that they don't overlap
>> * manual (uncheck auto and use the 9 little buttons below it to determine
>> the label position)
>>
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "steve" <steve@.discussions.microsoft.com> wrote in message
>> news:1997458C-5597-4680-A81F-9FCE96E04672@.microsoft.com...
>> > How can I get the point labes on a chart to appear inside the bar.
>>|||I already tried that. The graph is a horizontal bar left to right. The text
always displays ourside the bar to the right no matter which of the 9 muttons
I pick.
"Robert Bruckner [MSFT]" wrote:
> The 9 buttons represent the label position as follows: top-left,
> top-centered, top-right, middle-left, middle-centered, middle-right,
> bottom-left, bottom-centered, bottom-right. Just try it.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Steve" <Steve@.discussions.microsoft.com> wrote in message
> news:5A832C53-84F9-461E-83F1-36DCF8B12187@.microsoft.com...
> >I tried that and the labels are always outside the bar. I don't understand
> > where the 9 buttons are supposed to place the text.
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> >> Data point labels have two modes:
> >> * automatic (checkbox on the data point label tab) - this will move
> >> labels
> >> around so that they don't overlap
> >> * manual (uncheck auto and use the 9 little buttons below it to determine
> >> the label position)
> >>
> >>
> >> -- Robert
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >>
> >> "steve" <steve@.discussions.microsoft.com> wrote in message
> >> news:1997458C-5597-4680-A81F-9FCE96E04672@.microsoft.com...
> >> > How can I get the point labes on a chart to appear inside the bar.
> >>
> >>
> >>
>
>|||I had the same problem. I've unchecked the auto checkbox and
regardless of which position i set, top-left, top-centered, top-right,
middle-left, middle-centered, middle-right, bottom-left,
bottom-centered, etc... The label in my chart always displays at
"top-centered".
--Jordan
"=?Utf-8?B?U3RldmU=?=" <Steve@.discussions.microsoft.com> wrote in message news:<EC1E304D-350A-4A00-A75C-E75C972D08B9@.microsoft.com>...
> I already tried that. The graph is a horizontal bar left to right. The text
> always displays ourside the bar to the right no matter which of the 9 muttons
> I pick.
>
> "Robert Bruckner [MSFT]" wrote:
> > The 9 buttons represent the label position as follows: top-left,
> > top-centered, top-right, middle-left, middle-centered, middle-right,
> > bottom-left, bottom-centered, bottom-right. Just try it.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Steve" <Steve@.discussions.microsoft.com> wrote in message
> > news:5A832C53-84F9-461E-83F1-36DCF8B12187@.microsoft.com...
> > >I tried that and the labels are always outside the bar. I don't understand
> > > where the 9 buttons are supposed to place the text.
> > >
> > > "Robert Bruckner [MSFT]" wrote:
> > >
> > >> Data point labels have two modes:
> > >> * automatic (checkbox on the data point label tab) - this will move
> > >> labels
> > >> around so that they don't overlap
> > >> * manual (uncheck auto and use the 9 little buttons below it to determine
> > >> the label position)
> > >>
> > >>
> > >> -- Robert
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > >> rights.
> > >>
> > >>
> > >>
> > >> "steve" <steve@.discussions.microsoft.com> wrote in message
> > >> news:1997458C-5597-4680-A81F-9FCE96E04672@.microsoft.com...
> > >> > How can I get the point labes on a chart to appear inside the bar.
> > >>
> > >>
> > >>
> >
> >
> >|||Are you using a "stacked" chart? In this case, the label would always be
centered.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jordan" <jordanm@.37.com> wrote in message
news:9ae5dece.0504032015.42394c95@.posting.google.com...
>I had the same problem. I've unchecked the auto checkbox and
> regardless of which position i set, top-left, top-centered, top-right,
> middle-left, middle-centered, middle-right, bottom-left,
> bottom-centered, etc... The label in my chart always displays at
> "top-centered".
> --Jordan
> "=?Utf-8?B?U3RldmU=?=" <Steve@.discussions.microsoft.com> wrote in message
> news:<EC1E304D-350A-4A00-A75C-E75C972D08B9@.microsoft.com>...
>> I already tried that. The graph is a horizontal bar left to right. The
>> text
>> always displays ourside the bar to the right no matter which of the 9
>> muttons
>> I pick.
>>
>> "Robert Bruckner [MSFT]" wrote:
>> > The 9 buttons represent the label position as follows: top-left,
>> > top-centered, top-right, middle-left, middle-centered, middle-right,
>> > bottom-left, bottom-centered, bottom-right. Just try it.
>> >
>> > --
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> >
>> > "Steve" <Steve@.discussions.microsoft.com> wrote in message
>> > news:5A832C53-84F9-461E-83F1-36DCF8B12187@.microsoft.com...
>> > >I tried that and the labels are always outside the bar. I don't
>> > >understand
>> > > where the 9 buttons are supposed to place the text.
>> > >
>> > > "Robert Bruckner [MSFT]" wrote:
>> > >
>> > >> Data point labels have two modes:
>> > >> * automatic (checkbox on the data point label tab) - this will move
>> > >> labels
>> > >> around so that they don't overlap
>> > >> * manual (uncheck auto and use the 9 little buttons below it to
>> > >> determine
>> > >> the label position)
>> > >>
>> > >>
>> > >> -- Robert
>> > >> This posting is provided "AS IS" with no warranties, and confers no
>> > >> rights.
>> > >>
>> > >>
>> > >>
>> > >> "steve" <steve@.discussions.microsoft.com> wrote in message
>> > >> news:1997458C-5597-4680-A81F-9FCE96E04672@.microsoft.com...
>> > >> > How can I get the point labes on a chart to appear inside the bar.
>> > >>
>> > >>
>> > >>
>> >
>> >
>> >|||Hi,
Yes, I am using a "stacked" column chart. Can the labels be on top, as
in displayed outside the column/bar instead of "in" the column. Here's
an illustration:-
70
_____ _____
| 70 | | |
| | | |
_________ _____________
Current Required Display
Thanks.
--Jordan|||No, the chart control does not support explicit label positions if you use a
stacked (column, bar, area) chart.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jordan" <jordanm@.37.com> wrote in message
news:1113444867.671329.26860@.o13g2000cwo.googlegroups.com...
> Hi,
> Yes, I am using a "stacked" column chart. Can the labels be on top, as
> in displayed outside the column/bar instead of "in" the column. Here's
> an illustration:-
> 70
> _____ _____
> | 70 | | |
> | | | |
> _________ _____________
> Current Required Display
>
> Thanks.
>
> --Jordan
>

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 position not where expected

I have a simple column chart with point labels. The values are displaying at a -90 angle. I want the values to display in the center of the column, but when I choose the center position, it is displaying at the top; half of the value is in the bar and the other half above. Why?

I believe it places the point label as close to the position as you have set and attempts to avoid running into any other rendered images on your report.

You may want to try scaling the chart so that there is more room for the label to fit. Does your chart seem "crampted"?

|||I don't think it is cramped. There is a main chart which takes up the majority of the page. Then there are three smaller charts lined up vertically off to the right. It is these charts that I'm trying to get the point labels lined up correctly. There are only three bars per chart. To me, it doesn't look like there should be a problem with getting the label centered. I even tried making one of these charts much larger, and it did not change the position at all

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

Plotting lines and data points on scatter chart

I'm trying to produce a chart that has both actual data values from a database and matching "line of best fit" plots on the one chart. I have 4 data series, 2 of the actual data values and 2 that represent the values for the "line of best fit". What I want to do is:

Plot the actual values just as data points (joining them with lines in meaningless) and

Plot the "line of best fit" values as a line.

When I edit the data series on the scatter chart, I can see the "Plot data as line" option but it is "greyed" out.

Have I missed something really simple here or is this not possible. I'm using RS2005

Many thanks

Simon

Hi Simon,

I have the same problem now.

Have you found a solution for your problem?

Thanks

Gerd

Plotting lines and data points on scatter chart

I'm trying to produce a chart that has both actual data values from a database and matching "line of best fit" plots on the one chart. I have 4 data series, 2 of the actual data values and 2 that represent the values for the "line of best fit". What I want to do is:

Plot the actual values just as data points (joining them with lines in meaningless) and Plot the "line of best fit" values as a line.

When I edit the data series on the scatter chart, I can see the "Plot data as line" option but it is "greyed" out.

Have I missed something really simple here or is this not possible. I'm using RS2005

Many thanks

Simon

Hi Simon,

I have the same problem now.

Have you found a solution for your problem?

Thanks

Gerd

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

Plot data as line (is disabled on <Edit Chart Value> dialog)

I have a requirement to plot a line on the Area chart, and am wondering if
Reporting Services even allows us to do that ?
Right now, I am plotting the data using marker (X) however, it does not give
me adequate information of where does this particular Customer record fall on
an Area chart that has Lower Quartiles, Median and Upper Quartiles
(represented by filled area).
Thanks, in advance.Please read this thread, which describes how to combine Area & Line chart:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=fc74b95f-3746-4ac8-bbda-cebc857dc8f7&sloc=en-us
There is also an alternative approach for achieving this type of chart. A
sample is posted in this thread:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=37f3946e-55a7-4b2f-8af5-5c0290a7e4b5&sloc=en-us
--
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:52C60EAB-560F-4C2F-991D-D61FEE50C0C7@.microsoft.com...
> I have a requirement to plot a line on the Area chart, and am wondering if
> Reporting Services even allows us to do that ?
> Right now, I am plotting the data using marker (X) however, it does not
give
> me adequate information of where does this particular Customer record fall
on
> an Area chart that has Lower Quartiles, Median and Upper Quartiles
> (represented by filled area).
> Thanks, in advance.

Plot data as line

Why do I still have checkbox for Chart | Properties | .. <Plot data as line>
still DISABLED, even after applying SP1 ?
I however, see a button <Series Style> (which is right underneath the above
mentioned checkbox) now enabled after application of SP1. I must say that by
having <Series Style> I have gained a good control on applying color and
fonts..!
Thanks.Plot data as line only works for certain chart types. What type are you
trying to use?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:7DC3489A-D28F-4386-979E-C0FD4DC4EA5C@.microsoft.com...
> Why do I still have checkbox for Chart | Properties | .. <Plot data as
> line>
> still DISABLED, even after applying SP1 ?
> I however, see a button <Series Style> (which is right underneath the
> above
> mentioned checkbox) now enabled after application of SP1. I must say that
> by
> having <Series Style> I have gained a good control on applying color and
> fonts..!
> Thanks.|||Area Chart
"Brian Welcker [MSFT]" wrote:
> Plot data as line only works for certain chart types. What type are you
> trying to use?
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Kam" <Kam@.discussions.microsoft.com> wrote in message
> news:7DC3489A-D28F-4386-979E-C0FD4DC4EA5C@.microsoft.com...
> > Why do I still have checkbox for Chart | Properties | .. <Plot data as
> > line>
> > still DISABLED, even after applying SP1 ?
> >
> > I however, see a button <Series Style> (which is right underneath the
> > above
> > mentioned checkbox) now enabled after application of SP1. I must say that
> > by
> > having <Series Style> I have gained a good control on applying color and
> > fonts..!
> >
> > Thanks.
>
>