Excel Stacked Column Graph (3 Divisions for 3 Years)
Thank you very much for the information!
"HEK" wrote:
D1 D2 D3
MRI 2003 25000 8000 0
2004 28000 14000 0
2005 29000 15000 2500
<--- #N/A #N/A #N/A
XRay 2003 150000 52000 0
2004 149000 80000 0
2005 152000 79000 30000
I hope this matrix doesnt come out too mixed :-). Just select the squared
range w/ the data (from cell above MRI to 30000) and follow the chart
wizzard. The <--- is a dummy; if you make the cell empty instead it will
visually show as belonging to the MRI. You can replace it by a an empty
symbol. BTW, the data ranges are too different, and I wld make two different
charts to bring the message across... But I hope this helps anyway.
Take care,
Henk
"Brian" wrote:
The source data (not real numbers) would be as follows:
Division 1 X-Ray
2003 = 150,000
2004 = 149,000
2005 = 152,000
Division 1 MRI
2003 = 25,000
2004 = 28,000
2005 = 29,000
Division 2 X-Ray
2003 = 52,000
2004 = 80,000
2005 = 79,000
Division 2 MRI
2003 = 8,000
2004 = 14,000
2005 = 15,000
Division 3 X-Ray
2003 = -0-
2004 = -0-
2005 = 30,000
Division 3 MRI
2003 = -0-
2004 = -0-
2005 = 2,500
Thanks for your assistance!
" wrote:
Likely very do-able. What does the source data look like?
|