Question about chart legend

I have a chart and i am populating it from a sproc.

In the Legend i am getting InvestmentPercent.Value- InvestmentName.Value - InvestmentPercent.Value

How can I just display InvestmentPercent.Value - InvestmentName.value

In the graph it looks

3- cash -3

38 - FixedIncome -38

how can I set this thing right...

Regards

Karen

Karen,

I think what you are wanting to do is simply change the series label. Right click your chart -> properties -> data tab.

Click on the Value whose legend label you want to change. Then click Edit. Change the series label (not the value) to what you want.

If these steps are confusing, let me know and i'll post a screen shot.

|||

Can you pls post a screen shot.

Regards,

Karen

|||http://i55.photobucket.com/albums/g121/Farsight38/chart.jpg

http://i55.photobucket.com/albums/g121/Farsight38/chart2.jpg

If this isn't self explanatory, let me know.

|||

Greg,

Thanks for ur answer. it doesnt work.. having the same problem.

My sproc is as follows

ALTER Procedure [dbo].[rpt_FundAssetAllocation]

@.Cusip varchar(9)

AS

--temp dev code

/*declare @.Cusip varchar(9)

SET @.Cusip = '337739205' */

DECLARE

@.Period int

SELECT

@.Period = MAX([PeriodId])

FROM

FundAssetAllocation

WHERE

Cusip= @.Cusip

--==============================================================================

-- Return the appropriate data.

--==============================================================================

SELECT

Cusip,

InvestmentName,

InvestmentPercent

FROM

FundAssetAllocation

WHERE

Cusip = @.Cusip

AND

PeriodId = @.Period

So I have taken a Pie chart right clicked on it

and i have 2 values

the First one has the Following Series Label

=Fields!InvestmentPercent.Value + "% " + Fields!InvestmentName.Value and its Value is

=Count(Fields!InvestmentName.Value)

The second one is Value 2

which has the series Label of No value and its Value is

=Fields!InvestmentPercent.Value

The i also have a Series Group

Which i am grouping by Fields!Cusip.Value..

But when i preview it i am Getting the following legend

30 - 30% Intenational Stocks

40 - 40% U.S Mid/Large Cap Stock.

Regards

Karen

|||I'm not sure how to explain this, but I have seen occurances where the series label "sticks". I would change the series label to various things and see if you can get it to change to anything else.

|||

Thanks i will look into it. and i have another small problem. when i run the data set i have 3 records but when i plot it only 2 of them come up any idea why.

This is my Dataset

337739692 International Stocks 30
337739692 U.S. Mid/Large Cap Stock 40
337739692 U.S. Small Cap Stocks 30

and in the graph only the First 2 appear.

Any Help will be appreciated.

Regards,

Karen

|||

Greg,

thanks a Lot... I fixed it.. By removing the SeriesLabel in the values.

and about my previous post.. after fixing that it works Fine...

Regards

Karen