Is is possible to have in a pie chart BOTH the value with a currency format
and the 1,000 comma option on, with the percentage checked as well?
Is is possible to have in a pie chart BOTH the value with a currency format
and the 1,000 comma option on, with the percentage checked as well?
You might have to construct your own labels in an extra worksheet range,
using a formula like this:
=TEXT(B2,"$#,000.00")&CHAR(10)&TEXT(B2/SUM($B$2:$B$10),"0.0%")
then use a utility like those below to assign these labels to the pie
wedges:
Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
AKO wrote:
> Is is possible to have in a pie chart BOTH the value with a currency format
> and the 1,000 comma option on, with the percentage checked as well?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks