Thread: scatter chart with quadrants

Hi!

I'm new with excel 2003 and I don't know how to do a chart like one in the attached picture. Can anyone help me?

Thank you

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

I don't know how to change it.

Hi,

it is a bit difficult to describe in text so try this youtube link http://www.youtube.com/watch?v=TEJPCb4dnFk

It has a longish introduction but shows some sensible stuff from about 1:50

Hope this helps

I missed that this wasn't a standard scatter chart.

If I understand correctly the two perimeter axes are percentages. The two other axes are marked at the 50% positions and give actual values. Is this correct?

Not sure how you would do this.

I suspect you could do it by plotting the data for the additional two 'axes' as two additional XY series with lines and + point markers. Be helpful to see some sample data though.

PS I have no idea if the title has been changed or not, and therefore whether we are supposed to answer?

For good measure, seeing that the effort to change the title was made, I'll put in my suggestion.

As to the solution, attached is a XY scatter chart where the primary X and Y axes have been set to cross in the center of the chart, thus creating a quadrant with tick marks and labels.

The data points are plotted on the secondary X and Y axes. These have been set to plot the values in reverse order, which effectively puts them in the place of the primary axis position with the 100% showing in the lower left corner.

I'm quite proud of this, so someone please praise me.

How?

create a XY scatter chart with the data in F2:G3. connect the data points with a line. That should give you a vertical line
add a new series with the data in F5:G6. That should give you a horizontal line
add the data in columns A and B as a third series. set it to no lines.
assign the new data series to the secondary Y axis, this will show on the right
switch on the secondary X axis, this will show at the top
format the secondary Y axis to plot values in reverse order, this will move the axis to the left
format the secondary X axis to plot values in reverse order, this will more the axis to the bottom
format the primary x axis to cross the Y axis at 0, set the min to -20 and the max to 20
format the primary y axis to cross the x axis at 0, set the min to -20 and the max to 20

finally, format the first two data series to have no line and no marker to hide them.

It is a thing of beauty, m'lady and a work of genius!

R,

Thank you, kind Sir! My sentiments, exactly.

Well done.... but, you knew there would be a but

The inner scales are not linear. Notice the distance between values.
You would need to calculate the x/y positions and use another series with linked data labels to draw those inner scales.

The depending on the data you either plot against the true axes or you recalculate to plot against the inner scales.

The inner scales are not linear. Notice the distance between values.

Yes, I saw that. Also, they don't cross at zero. I didn't worry about that too much, though because I knew once the principle construction is there, the axis labelling can be done with the usual methods.