bar-of-pie

  • Thread starter Thread starter AndyM
  • Start date Start date
A

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.
 
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
 
Back
Top