Hi, I was wondering if there is any way that I can present data labels for a series within a pie chart in the following format:
[Category Name] ([Value]) [Percentage]
So an example would be:
New Business (120) 64%
I have looked within the options and it only seems to give you the option to separate by comma or space etc, I can't seem to find a way to put brackets just around the value part. Is there a way around this? Also, is there any way to put a formula within a chart title?
Thanks,
Ben
Simplest thing to do is use formula to build the required information and use that as the category labels.
Then you just use normal data labels and display Category.
Rather than formula in title you link the title to a cell. The cell contains the required formula.
http://www.andypope.info/tips/tip001.htm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks