bar-of-pie

[AndyM]

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.

 

[Jon Peltier]

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