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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top