A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How to display both $ in pie chart and % in legend



 
 
Thread Tools Display Modes
  #1  
Old January 19th, 2010, 07:29 PM posted to microsoft.public.excel.charting
Christi
external usenet poster
 
Posts: 55
Default How to display both $ in pie chart and % in legend

I have a spreadsheet in excel that has some simple data
Total-C $90 59%
Total-K $24 15%
Total-L $40 26%

I'd like to display this info in a pie chart, but more specifically, I'd
like to have the $ over the slices, and the % in the legend. I have been able
to display both in the slices. I've serched for tutorials, but nothing
indicates that what I am trying to do is possible without just typing in the
percent as part of the series names. Any suggestions?

Thanks, Christi
  #2  
Old January 20th, 2010, 08:57 AM posted to microsoft.public.excel.charting
FloMM2
external usenet poster
 
Posts: 189
Default How to display both $ in pie chart and % in legend

Christi,
This is what I came up with:
Cell A2 "Total-C" Cell B2 "$90" Cell C2 "59%"
Cell A3 "Total-K" Cell B3 "$24" Cell C3 "15%"
Cell A4 "Total-L" Cell B4 "$40" Cell C4 "26%"

On the Series tab, Series1 select, Name: "=Sheet1!$A$2", Values:
="Sheet1!$B$2:$B$4", Category Labels: "=Sheet1!$C$2:$C$4"
Series2 select, Name: "=Sheet1!$A$3", Values: "=Sheet1!$C$2:$C$4",
Category Labels: "=Sheet1!$C$2:$C$4"
Add a series, Series3 select, Name: "= Sheet1!$A$4", Values:
"=Sheet1!$C$2:$C$4", Category Labels: "=Sheet1!$C$2:$C$4"

This will change the chart legend to the percentages listed.
"Christi" wrote:

I have a spreadsheet in excel that has some simple data
Total-C $90 59%
Total-K $24 15%
Total-L $40 26%

I'd like to display this info in a pie chart, but more specifically, I'd
like to have the $ over the slices, and the % in the legend. I have been able
to display both in the slices. I've serched for tutorials, but nothing
indicates that what I am trying to do is possible without just typing in the
percent as part of the series names. Any suggestions?

Thanks, Christi

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:34 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.