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

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
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
379
AndyEd
A
J
  • Question
Multi Y-Axis plot not matching individual dates
Replies
0
Views
213
jungle125
J
B
  • Solved
vba code to extend graph
Replies
1
Views
852
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
461
Jon Peltier
J

Forum statistics

Threads
1,214,522
Messages
6,120,022
Members
448,939
Latest member
Leon Leenders

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