Scatterplot with 4 quadrants
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 |
Scatterplot with 4 quadrants
http://peltiertech.com/Excel/Charts/AddLine.html
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "dhill" wrote in message ... 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 |
Scatterplot with 4 quadrants
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. On Tue, 22 Jul 2008 10:30:09 -0700, dhill wrote: 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 |
All times are GMT +1. The time now is 06:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com