Problem with uneven scale for X or Y axis.

ccy

New Member
Joined
Nov 18, 2005
Messages
5
Just wondering if the experts here know how generate an XY scatter plot with uneven interval for X and Y axis?
Both data points for X and Y ranges widely from 10 to 10000 with majority of them concentrated on the range between 10-3000. As a result, I want more details for lower range and less details for upper range
Is there any tricks to do it?
Thanks
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

jolivanes

Well-known Member
Joined
Sep 5, 2004
Messages
1,669
Office Version
  1. 2013
  2. 2007
Platform
  1. Windows
Would the logarithmic scale work for you? Format Axis and choose logarithmic scale.
John
 

Watch MrExcel Video

Forum statistics

Threads
1,118,033
Messages
5,569,777
Members
412,291
Latest member
marypolitan
Top