Thread: bar-of-pie
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Andym Andym is offline
external usenet poster
 
Posts: 35
Default bar-of-pie

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.