Discussion on:

Differentiate pie slices with Excel's Bar Of Pie chart option

started the operation and could not find the chart wizard on a standard Offcie 2007 install

checked the help but no mention of chart wizard checked google and all reference is to Excell 2003

wazzup

In Office 2007, use the ribbon to INSERT > Pie Chart. Go from there.

This is a great procedure for Excel 2003- I love it!

How about a procedure for doing it in Excel 2007 as well? I tried it in both versions and it works really slick in 2003 but I don't know how to get to where I change the legend settings and other things in 2007 yet. A step-by-step for that version would be really nice.

Actually, a great idea would be to advise right up front what version of Office your tips are for. Can that be made the norm, please? Thanks!

I just realized that the ribbon changes when you select the chart.

So from there just select the layout you want (in this case the percentage layout), then right click the data values, select Format Data Series, and the rest is history (or at least, the same as in the 2003 instructions).

Piece of cake... I mean, pie!

If you want the total of the pie slices to equal 100%, format the percentage numbers to 2 decimals.

This works really well. The only comment is that the percentages don't add up to 100% unless you show 2 decimal places -- shows "other" equals 12%, but 6, 4 and 3 add up to 13. I like this pie chart. Thanks for the information.

Would be nice to see image of examples to help understand each tip.

I agree, it would be a tremendous help for us visually-oriented folks if step-by-step graphics were supplied as well. Even just a picture of the end product would be a significant help. And yes, also please specify what version the tip applies to, or provide alternate steps as you go.

Thanks. I work w/ Excel a lot, but charts very little, and articles like this help keep me from getting too rusty.

However, I second holmescd re: always naming the version. I haven't seen any need to upgrade Office since 2K, and was thrown off a bit when I couldn't find the check boxes in 25 - 26, but the rest of the steps worked fine.

worked great - shame on me for not knowing that option was there - thanks for the info on the decimals also - never too old to learn

Say, we got a table 'A' and Category 4 is one of the categories in table A. We want to emphasise on the chart, Table B, which is items of Category 4, where as we don't care as much to the items of category 1-3.
Table A
Category 1
Category 2
Category 3
Category 4 -> Table B
Item1
Item2
Item3

Is it possible to do it from 2 Data series?... My current solution right now is like this, put it one table with category 4 straight away broken down to item 1 to 3

Table A
Category 1
Category 2
Category 3
Item1
Item2
Item3