4 Quadrant XY Chart want the "cross hairs" of my chart to be 1-1 instead of 0-0 EASY? NOPE

[Neil45]

Without the chart getting all lop sided is there a way that u can change the axis value to 1 instead of 0.

my example is:

Untitled.png

[Neil45]

Sorry I am new, i wanted to display the picture in my post..

[Andy Pope]

An example file would be much more helpful.

If you want 1,1 to be at the center you will need to adjust the min/max values to be be -2/4

[Peter.M]

Is this what you need?

axis1.xlsx

If so, for x and y axis:

Right click axis > format Axis > Axis options
Axis value, set to 1

[Neil45]

I have attached a file. The center of the bullseye needs to be 1-1. its for a performance factor. Goal is 1, anything less is bad, above is also bad.

quadrant chart.xlsx