P
pcook9112
I am working on creating a chart to compare data from two of our
programs each with four measures over a four year period of time. A
little hard to explain so I will create an example below:
PY 2000-2001 PY 2001-2002
Measure(M) 1 M 2 M 3 M 4 M 1 M 2 M 3 M 4
Adult 145 48 53 45 231 91 98 42
Youth 350 219 16 115 289 128 88 73
I hope that comes out alright. I envision a bar chart with four sets
of different colored bars, color based on year and all measure being
seperate sets of bars. I need to show the trend over years for each
measure. I can actually show that with the 3-D column chart but it is
not quite right. The y-axis shows PY 00-01 etc, the z-axis shows the
counts, but the x-axis has four numbers, 1, 2, 3, 4.
The problem could be how I am representing my data in the spreadsheet
or it could be that excel just cannot compare the three different
variable very well. Based on other responses in this newsgroup I am
confident that someone can set me straight regardless of the source of
the problem.
TIA,
Paul
programs each with four measures over a four year period of time. A
little hard to explain so I will create an example below:
PY 2000-2001 PY 2001-2002
Measure(M) 1 M 2 M 3 M 4 M 1 M 2 M 3 M 4
Adult 145 48 53 45 231 91 98 42
Youth 350 219 16 115 289 128 88 73
I hope that comes out alright. I envision a bar chart with four sets
of different colored bars, color based on year and all measure being
seperate sets of bars. I need to show the trend over years for each
measure. I can actually show that with the 3-D column chart but it is
not quite right. The y-axis shows PY 00-01 etc, the z-axis shows the
counts, but the x-axis has four numbers, 1, 2, 3, 4.
The problem could be how I am representing my data in the spreadsheet
or it could be that excel just cannot compare the three different
variable very well. Based on other responses in this newsgroup I am
confident that someone can set me straight regardless of the source of
the problem.
TIA,
Paul