On Mon, 25 Aug 2008, in microsoft.public.excel.charting,
Karen said:
It just numbers the pieces and gives me the wrong percentages. Does anyone
know what could be happening? Can I use a pie chart for currency or should I
use a bar chart?

You actually should use a bar chart, but regardless of the chart type,
it helps the Chart Wizard if you label the second column with a title at
the top, like this:

Number
$125 6
$150 3
$250 49
$275 5
$300 2
$500 59

Leave the cell on the left, above the dollars, blank, to tell the wizard
that that's your category axis labels. Now make your chart by selecting
the range, including the top row with the label and the blank cell in.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.