Create an axes coordinate with an Excel graphic

[lanz]

Hi,

Anybody knows if with Excel it can be created a graphic of an axes coordinate, which represents -X, X, -Y and Y points?

Thanks with anticipation.

Regards

[Andy Pope]

Not sure I understand the question but do you mean xy-scatter chart?

[lanz]

Hi Andy

Yes.

Regards

[Andy Pope]

So yes you can create xy-scatter charts.

Normally your data would be in 2 columns

X values and Y Values

[lanz]

But, can you create a chart like this?

http://upload.wikimedia.org/wikipedi...ate-system.svg

[Andy Pope]

Yes. Using Error bars for the dotted lines is probably the simplest approach

[lanz]

Hi Andy,

I am very interested to know how to do that the example you have done.

Regards

[Andy Pope]

Select the range A1:B5 and create a xy-scatter chart.

Double click the series and set the X-Error bars to a custom minus range of A2:A5
Set the Y Error bars to a custom minus range of B2:B5
Format error bars to have no cap and dotted line.
Add data labels of X and Y value with separator of comma

[lanz]

Hi,

Using your example, and using the graphic kind "Lines of Dispersion", I have created the coordinate axes.

Itīs Ok, but in my opinion the points are not enough visible, and the dotted lines also are not enough visible.

Is it possible to do the same graphic, but using other king of graphic like bars to emphasize the points?

Regards

[Andy Pope]

Can you post what you currently have.

By bars do you mean shaded colour areas?

[lanz]

I mean columns bars

PD:The example I have uploaded is wrong but is to have an idea what I want to obtain: your coordinate axe, but with a format of column bars, if it is possible.

Regards

[Andy Pope]

Is this the sort of thing you mean?

If not use shapes to construct a more realistic image of what you are after.

[lanz]

Yes Andy, it is. Thank you very much

[Andy Pope]

Create the xyscatter chart as before.
The add 4 new series.
Move to the secondary axis
Chart chart types to area
Set source data for series and secondary x axis via source data dialog.
Via chart options set Secondary x axis to be Time Series

Set secondary x axis to min=10 max=90, this will allow for 0.1 increments on the axis.

Set secondary y axis to Min=-4 max=4 uncheck crosses at maximum

[lanz]

Thank you very much andy, I am very grateful.

Regards