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
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

jolivanes

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

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,118
Messages
5,835,492
Members
430,359
Latest member
ManuelCukRia

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top