Solved

Pie chart - show that it is a percentage

Posted on 2014-12-19
4
168 Views
Last Modified: 2014-12-23
In the screen shot I would attach i need to add a percentage sign after all the numbers that are on this bar chart.  How would i do so?

pie-chart.JPG
0
Comment
Question by:vbnetcoder
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 

Author Comment

by:vbnetcoder
ID: 40509442
So it would say 50 %, 28.13 5 etc
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 250 total points
ID: 40510443
Is this SSRS?
Try these steps from MS

To display percentage values as labels on a pie chart
http://technet.microsoft.com/en-us/library/dd239373(v=sql.110).aspx

Add a pie chart to your report. For more information, see Add a Chart to a Report (Report Builder and SSRS).

On the design surface, right-click on the pie and select Show Data Labels. The data labels should appear within each slice on the pie chart.

On the design surface, right-click on the labels and select Series Label Properties. The Series Label Properties dialog box appears.

Type #PERCENT for the Label data option.

(Optional) To specify how many decimal places the label shows, type "#PERCENT{Pn}" where n is the number of decimal places to display. For example, to display no decimal places, type "#PERCENT{P0}".

mlmcc
0
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 250 total points
ID: 40514651
Right-hand click on the percentage values.
Go to Properties (press F4) - Misc - Format.
Type the following in Misc - Format:

0"%"

Open in new window


Please note, it does not convert it into percentages, it merely adds the % sign afterwards, which was your question.
0
 

Author Closing Comment

by:vbnetcoder
ID: 40514810
ty
0

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Reformat SQL - so SSRS can read the columns 25 47
SSRS 2013 - Finding Datasets/StoredProcedures 4 54
SQL Select Query help 1 49
Trying to understand why my Index is so large 12 52
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question