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

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
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
392
AndyEd
A
J
  • Question
Multi Y-Axis plot not matching individual dates
Replies
0
Views
219
jungle125
J
B
  • Solved
vba code to extend graph
Replies
1
Views
862
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
466
Jon Peltier
J

Forum statistics

Threads
1,214,829
Messages
6,121,827
Members
449,051
Latest member
excelquestion515

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