Pie charts are not very effective, and for your situation, I'd guess they're
even worse.

I would instead make a clustered column chart, series in rows, so A thru E
are the horizontal axis labels, and series 1 and 2 are plotted next to each
other. I wouldn't bother with a third series for the difference between
them, since it's rather evident.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"AndyM" wrote in message
...
I would like to produce a graph using the following data:
A B C D E
1 $18,134 $768,124 $678,589 $474,675 $341,879
2 $0.00 $424,935 $498,663 $424,570 $198,233

I would like the components of row 1 to be the data comprising each slice
of
the pie (5 slices, A through E). I'd like a bar for each pie slice, to be
represented by two figures, the number in row 2 and the difference between
the numbers in row 2 and 1 (e.g. both numbers in the bar must add up to
the
pie slice value (that in row 1). I am having a heck of a time in trying
to
do this for one slice, let alone all five of them. Any help would be
appreciated.