MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Quadrant charts


Posted by Matt Jowett on June 20, 2001 12:32 AM

I have data on average health and income for 20 Indian states. I want to plot these on a quadrant chart i.e. only one point representing each state which can thus be read against health (x-axis) and income (y-axis). The chart should be split into 4 quads to see where the states fall. Can anyone help - whenever I try I always get two points plotted for each state.

Cheers, Matt.


Posted by Mark W. on June 20, 2001 8:57 AM

Suppose cells A1:C4 contains...

{"State","Health","Income"
;"CO",95,100
;"NM",84,96
;"AZ",78,85}

The following SERIES formula should do the
trick...

=SERIES(,Sheet2!$B$2:$B$4,Sheet2!$C$2:$C$4,1)

Next, you'll want to select the chart and choose
the Chart | Chart Options... menu command.
Select Show label on the Data Labels tab. Finally,
you'll need to select each label in turn, type
an equal sign, and click on the appropriate
State value.