question about charts

I have a pie chart which is been populated from a sproc.

and for a particular fund the values that generate are 78%,20% and 2% respectively.

And when it generates a chart the pie chart is uniformly displayed... Like for eg.. its been broken into 3 parts and there isnt a difference between the 78% and the 2% so ... How can i get the pie chart to be a displayed according to its values..

Any help will be appreciated..

Regards

Karen

So you are saying that each piece of the pie is showing as one third of the pie instead of being divided according to the percentage if you have three values in the pie chart?

Have you tried an exploded pie with 3D effects? Have you displayed the value for each piece of the pie on the chart?

Since it is a pie chart, it should naturally divide the pie according to the values in the chart.

If not, it would be like a bar graph with all of the bars at the same height when the values were in fact different.

|||

i have a exploded pie chart ... in design mode i can see the differences but not when i preview it..

Regards

KAren

|||

So when you preview it you can see the percentages over the pieces of the pie, but it looks as if it's not dividing it accordingly?

I'm making sure I understand the problem...

|||Maybe it's having a problem with the percentage itself. Is your field in itself a percentage? If so, I don't think it should be. The field itself should be a number (not a percentage) and the pie chart will divide the number by the total to get the percentage behind the scenes. You don't need to make it a percentage yourself.|||

greg,

The fields is varchar field in Sql server and i am not doing any thing special in the report..

78% part should be bigger than 2 % but 78% and 2% are the same size.

So how can i solve it

Regards

Karen

|||

i changed the datatype to decimal and it works fine.

Thanks

Regards,

Karen

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