Formatting point labels on a stacked column chart

I have a stacked column chart with two series. The chart by default is
showing point labels in the middle of the bar for each series for each
category on X-axis. I also need to have a label at the top of each
stacked column repesenting sum of Y values for each X value. So if one
series Y value is 5 and second 10 for a particular X value, I need to
show both point labels and a third label at the top of the column
showing 15. Thank you for any feedback.Alibronek,
On the data tab of the chart properties add a new value to the chart, with
the expression of field1 + field2. On the appearance tab check the plot data
as line. This will give you a line above the bars, if you play around with
the markers and style you should be able to hide the line and only show the
markes.
AK Code Rat
"Alibronek" wrote:
> I have a stacked column chart with two series. The chart by default is
> showing point labels in the middle of the bar for each series for each
> category on X-axis. I also need to have a label at the top of each
> stacked column repesenting sum of Y values for each X value. So if one
> series Y value is 5 and second 10 for a particular X value, I need to
> show both point labels and a third label at the top of the column
> showing 15. Thank you for any feedback.
>sql

Formatting numbers in charts

Is there a property or hack that would allow for the numbers (for each
series) in a piechart to appear OUTSIDE the "pie" itself. In other words the
numbers displayed outside the series with lines or arrows pointing to the
corresponding "piece?"
the intent of course is to allow users to see the number when the series is
too small to fit the number inside the chart
thanks?"Outside" labels for pie and doughnut charts were added in RS 2000 SP1.
Check the Readme file of SP1 / SP2:
http://download.microsoft.com/download/5/1/3/513534ae-a0e7-44e6-9a04-ba3c549a5f5f/sp2Readme_EN.htm#_chart_enhancements
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"neokortex" <neokortex@.discussions.microsoft.com> wrote in message
news:C6F25E23-7719-41E7-9DFD-A103501D1AA6@.microsoft.com...
> Is there a property or hack that would allow for the numbers (for each
> series) in a piechart to appear OUTSIDE the "pie" itself. In other words
> the
> numbers displayed outside the series with lines or arrows pointing to the
> corresponding "piece?"
> the intent of course is to allow users to see the number when the series
> is
> too small to fit the number inside the chart
> thanks?|||This works by the way...although oddly the changes are not visible in the VS
IDE..only after it was uploaded to the server
thanks
"Robert Bruckner [MSFT]" wrote:
> "Outside" labels for pie and doughnut charts were added in RS 2000 SP1.
> Check the Readme file of SP1 / SP2:
> http://download.microsoft.com/download/5/1/3/513534ae-a0e7-44e6-9a04-ba3c549a5f5f/sp2Readme_EN.htm#_chart_enhancements
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "neokortex" <neokortex@.discussions.microsoft.com> wrote in message
> news:C6F25E23-7719-41E7-9DFD-A103501D1AA6@.microsoft.com...
> > Is there a property or hack that would allow for the numbers (for each
> > series) in a piechart to appear OUTSIDE the "pie" itself. In other words
> > the
> > numbers displayed outside the series with lines or arrows pointing to the
> > corresponding "piece?"
> >
> > the intent of course is to allow users to see the number when the series
> > is
> > too small to fit the number inside the chart
> >
> > thanks?
>
>|||Yes, outside labels are not shown at design time - only in preview or when
rendering on the server.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"neokortex" <neokortex@.discussions.microsoft.com> wrote in message
news:B7135406-41AD-4A8F-A161-B242C13EA033@.microsoft.com...
> This works by the way...although oddly the changes are not visible in the
> VS
> IDE..only after it was uploaded to the server
> thanks
> "Robert Bruckner [MSFT]" wrote:
>> "Outside" labels for pie and doughnut charts were added in RS 2000 SP1.
>> Check the Readme file of SP1 / SP2:
>> http://download.microsoft.com/download/5/1/3/513534ae-a0e7-44e6-9a04-ba3c549a5f5f/sp2Readme_EN.htm#_chart_enhancements
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "neokortex" <neokortex@.discussions.microsoft.com> wrote in message
>> news:C6F25E23-7719-41E7-9DFD-A103501D1AA6@.microsoft.com...
>> > Is there a property or hack that would allow for the numbers (for each
>> > series) in a piechart to appear OUTSIDE the "pie" itself. In other
>> > words
>> > the
>> > numbers displayed outside the series with lines or arrows pointing to
>> > the
>> > corresponding "piece?"
>> >
>> > the intent of course is to allow users to see the number when the
>> > series
>> > is
>> > too small to fit the number inside the chart
>> >
>> > thanks?
>>