Problem with uneven scale for X or Y axis.

C

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

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Sort by date Sort by votes
Would the logarithmic scale work for you? Format Axis and choose logarithmic scale.
John
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
Calendar form cancel button passing data to worksheet
Replies
7
Views
384
AndyEd
A
J
  • Question
Multi Y-Axis plot not matching individual dates
Replies
0
Views
215
jungle125
J
B
  • Solved
vba code to extend graph
Replies
1
Views
853
bryanrobson
B
A
  • Solved
Calendar issue
Replies
1
Views
1K
AndyEd
A
M
  • Question
How to swap graph axis' for large amounts of data?
Replies
1
Views
464
Jon Peltier
J

Forum statistics

Threads
1,214,642
Messages
6,120,700
Members
448,979
Latest member
DET4492

Share this page

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
Back
Top