Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
bar-of-pie
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|