Getting All Data On Chart

  • Thread starter Thread starter pcook9112
  • Start date Start date
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
 
If you set up the data like this:

2000 2001
Adult M1 145 231
M2 48 91
M3 53 98
M4 45 42
Youth M1 350 289
M2 219 128
M3 16 88
M4 115 73

and create a clustered column chart, the series will be coloured by year.
 
Back
Top