Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peace2007
Posting Yak Master
239 Posts |
 Posted - 2009-02-11 : 05:36:26
|
| Hi, How can I display % on pie chart slices? Currently normal numbers are displayed on my pie chart! |
|
|
Rajesh Jonnalagadda
Starting Member
45 Posts |
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2009-02-11 : 08:40:19
|
| it worked thanks :) |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-11 : 08:52:24
|
quote:
Originally posted by Peace2007
Hi, How can I display % on pie chart slices? Currently normal numbers are displayed on my pie chart!
you've standard percentage available as a option in format tab of chart labels tab |
|
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2009-02-14 : 01:40:10
|
| Do you mean Chart properties-> values edit button -> point labels tab -> format code edit text ? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-14 : 01:45:01
|
| yup. just give="P" |
|
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2009-02-14 : 01:52:48
|
| ok thanks :)it works great |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-14 : 02:07:11
|
| and if yoiu dont want decimals try ="P0" |
|
|
|
LadySharon
Starting Member
1 Post |
Posted - 2011-11-04 : 14:36:34
|
| Hello. I am an End user (ie no way to change stuff behind the scenes) - this is at my work btw. I'm trying to figure out how to change the numbers to percents... but what you present here is not apperently avalible to me. When I clicked on the link it just said something like "click on the lable in your layout" which isn't clickable.I have a design report and a run report tab. My about microwsoft report builder says it's Microsoft SqlServer 2005, version 9.00.5000.00 This looks like the right place... but maybe it's not? I can right click on the data element (on the top of the pie chart right below the "click to add title" area)And I get the following two choices:Format data series andedit formula. Neither of these takes me to anything you guys have mentioned on this thread. I don't even SEE the lables until I click "add point lables" Clicking on anything in the chart in the "run report" area makes it show as a data set. So I'm guessing I'm supposed to click on stuff in the design report area. Hoewver double clicking on the fake lable does nothing. Neither does clicking on the lables to the right. In fact left clicking anywhere once I have the chart selected - really doesn't do anything. I can right click on the data fields but that's it. Maybe a formula? I'd show you what I see but I am not allowed to save and upload jpgs (and I don't know if I can display them on your message board anyway.)Thank you for your time.- Sharon |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-05 : 13:31:31
|
| whatever we have discussed here are features on report server project not on report builder. report builder is wizard driven and has veru few options on designer compared to report server project------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Displaying Precent in Pie Chart