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

Plot area size

I am having a terrible time 'fixing' the plot area in charts. Also the
size and location of legends. It just keeps making its own
decisions...
Keeps making too much space between the right edge of the chart and
the end of the plot are...
And doesn't seem to have any properties...
Any ideas?You can determine the position of the legend ("Legend" tab in the chart
properties dialog). Did you try putting the legend at the bottom of the
chart? The space consumed by the legend in RS 2000 is determined
automatically.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Harsh" <creative@.mailcity.com> wrote in message
news:fa671a26.0407190838.2460ee91@.posting.google.com...
> I am having a terrible time 'fixing' the plot area in charts. Also the
> size and location of legends. It just keeps making its own
> decisions...
> Keeps making too much space between the right edge of the chart and
> the end of the plot are...
> And doesn't seem to have any properties...
> Any ideas?|||1.
I am using a horizontal bar graph.
I tried putting the legend at the bottom. I am not concerned about the
legend sizing.
The plot area size is still smaller than what I expect. It still
leaves space on the right. And crumples the numbers inside...
(Maybe a bug in Horizontal graphs)
2.
I also tried changing the colors/ borders.
- If I put multiple items in the 'series area' in a horizantal bar
graph - I can't change the colors anymore...because you only have that
option on value. I think you should also have color options on series.
3.
Honestly... the options on sizing are limited.
- Give us control on plot area size.
4.
Tooltip on graphs...|||#2: you have still control over the color - but you have to write an
expression rather than a constant. I assume you added a "series grouping" by
dropping a field into the series area. When you examine that series grouping
you will see a grouping expression like =Fields!Year.Value.
Lets assume your series grouping is called "YearGroup". On the series styles
of the datapoint, you would use a similar expression to control the color:
=Switch(CInt(First(Fields!Year.Value, "YearGroup")) = 2000, "Red",
CInt(First(Fields!Year.Value, "YearGroup")) = 2001, "Yellow")
The important part is the aggregate scope which has to be identical to the
chart series grouping name. Just using the First aggregate without the scope
will give you incorrect results.
#1 / #3 / #4: your feedback is appreciated. You can expect improvements in
these areas in future releases.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Harsh" <creative@.mailcity.com> wrote in message
news:fa671a26.0407200708.22503755@.posting.google.com...
> 1.
> I am using a horizontal bar graph.
> I tried putting the legend at the bottom. I am not concerned about the
> legend sizing.
> The plot area size is still smaller than what I expect. It still
> leaves space on the right. And crumples the numbers inside...
> (Maybe a bug in Horizontal graphs)
>
> 2.
> I also tried changing the colors/ borders.
> - If I put multiple items in the 'series area' in a horizantal bar
> graph - I can't change the colors anymore...because you only have that
> option on value. I think you should also have color options on series.
>
> 3.
> Honestly... the options on sizing are limited.
> - Give us control on plot area size.
>
> 4.
> Tooltip on graphs...|||> #2: you have still control over the color - but you have to write an
> expression rather than a constant. I assume you added a "series grouping" by
> dropping a field into the series area. When you examine that series grouping
> you will see a grouping expression like =Fields!Year.Value.
> Lets assume your series grouping is called "YearGroup". On the series styles
> of the datapoint, you would use a similar expression to control the color:
> =Switch(CInt(First(Fields!Year.Value, "YearGroup")) = 2000, "Red",
> CInt(First(Fields!Year.Value, "YearGroup")) = 2001, "Yellow")
> The important part is the aggregate scope which has to be identical to the
> chart series grouping name. Just using the First aggregate without the scope
> will give you incorrect results.
This works! Great Thanks!
The following coupled with the above would make the graphing
capabilities better:
1. Control on position of Point Labels. (like vert. horiz. distance
from edges... etc.)Current positioning is not always great.
2. Color and position changes for Markers. Expression based would be
great.
3. Control to make a half/ resized dougnnut.
4. Control for width of bars etc..
5. Guage and Radar are essential graph types. Please consider those.
And previously suggested:
3. Give us control on plot area size.
4. Tooltip on graphs...
Great product and very promising graphing engine. The above items
would make it my preferred graphing engine.|||#1: Point labels - we are considering this for the next release
#2: Marker color - you can do this today - however right now it is only
supported in RDL and on the report server. E.g.
<Marker>
<Type>Diamond</Type>
<Size>10pt</Size>
<Style>
<BackgroundColor>="Yellow"</BackgroundColor>
</Style>
</Marker>
#4: Width of bars - you can do it today:
http://groups.google.com/groups?selm=eG99i3sZEHA.4092%40TK2MSFTNGP11.phx.gbl
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Harsh" <creative@.mailcity.com> wrote in message
news:fa671a26.0407210723.546a5103@.posting.google.com...
> > #2: you have still control over the color - but you have to write an
> > expression rather than a constant. I assume you added a "series
grouping" by
> > dropping a field into the series area. When you examine that series
grouping
> > you will see a grouping expression like =Fields!Year.Value.
> > Lets assume your series grouping is called "YearGroup". On the series
styles
> > of the datapoint, you would use a similar expression to control the
color:
> > =Switch(CInt(First(Fields!Year.Value, "YearGroup")) = 2000, "Red",
> > CInt(First(Fields!Year.Value, "YearGroup")) = 2001, "Yellow")
> > The important part is the aggregate scope which has to be identical to
the
> > chart series grouping name. Just using the First aggregate without the
scope
> > will give you incorrect results.
>
> This works! Great Thanks!
>
> The following coupled with the above would make the graphing
> capabilities better:
> 1. Control on position of Point Labels. (like vert. horiz. distance
> from edges... etc.)Current positioning is not always great.
> 2. Color and position changes for Markers. Expression based would be
> great.
> 3. Control to make a half/ resized dougnnut.
> 4. Control for width of bars etc..
> 5. Guage and Radar are essential graph types. Please consider those.
>
> And previously suggested:
> 3. Give us control on plot area size.
> 4. Tooltip on graphs...
>
> Great product and very promising graphing engine. The above items
> would make it my preferred graphing engine.|||> however right now it is only supported in RDL and on the report server
I am sorry - I don't follow you when you say - only on the report server.
Does that mean I can't make SOAP calls without breaking these.|||No this has nothing to do with SOAP.
It means that you can get this behavior only by manually modifying the RDL
file. If you load that modified RDL file in report designer and change
layout settings in the report, the report designer will most likely
"destroy" your manual RDL changes when applying the layout changes.
You can still just load and preview the manually modified RDL files in
report designer. You can also upload them to the server through report
designer.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Harsh" <creative@.mailcity.com> wrote in message
news:fa671a26.0407220623.3b3d09a0@.posting.google.com...
> > however right now it is only supported in RDL and on the report server
> I am sorry - I don't follow you when you say - only on the report server.
> Does that mean I can't make SOAP calls without breaking these.