Scatterplot with 4 quadrants

D

dhill

I would like to set a scatterplot that has a crosshairs grid view. When you
set major grid lines, it populates several vertical and horizontal lines; i
would like to have one vertical and one horizontal lines.

thanks
 
T

Tushar Mehta (Microsoft MVP Excel 2000-2008)

Don't use any grid lines. Instead, adjust the X and Y axis to give
you the desired effect. In each case, set the axis parameter so that
it intersects the other axis at the midway point.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

mixed plot: scatter, vertical, and horizontal lines 4
adding data labels to an XY scatterplot 1
ScatterPlot Major and Minor Horizontal Gridlines not showing 3
How do I create a Power-Interest Griid in microsoft excel 1
Scatterplot with a best-fit line 1
Data Lables, series and Scatterplots 2
How do you make a chart with right angles only? 12
Show horizontal grid lines only in xl2003.. 1

Top