If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Compressed part of an axis
Is it possible to get Excel to compress a part of an axis, while let
the other part have the axis expanded. I.e: y value 1 to 100 with a tick of 10, while value 100 to 1000 a tick of 100. Is this possible in Excel, or does one needs SPSS or other packages for this? TIA, Haagen |
#2
|
|||
|
|||
Compressed part of an axis
Hi,
There is no built in way to do this. You can create your own ticks and labels. See Jon Peltier's page for examples of how to do this. http://peltiertech.com/Excel/Charts/ArbitraryAxis.html Cheers Andy wrote: Is it possible to get Excel to compress a part of an axis, while let the other part have the axis expanded. I.e: y value 1 to 100 with a tick of 10, while value 100 to 1000 a tick of 100. Is this possible in Excel, or does one needs SPSS or other packages for this? TIA, Haagen -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
Compressed part of an axis
With a linear scale going to 1000, the 10's ticks would practically
merge together. Dobule click on the axis; from the Format Axis dialog, select tab Scale tab and check Logarithmic (leave all scaling automatic); select the Patterns tab and set Minor tick marks to display Outside of the axis. Is this the look you were wanting? Jerry wrote: Is it possible to get Excel to compress a part of an axis, while let the other part have the axis expanded. I.e: y value 1 to 100 with a tick of 10, while value 100 to 1000 a tick of 100. Is this possible in Excel, or does one needs SPSS or other packages for this? TIA, Haagen |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
primary & secondary axis - format labels & positioning | Maureen D. | Powerpoint | 5 | November 3rd, 2005 03:22 AM |
Auto filling fields | access | General Discussion | 3 | October 24th, 2005 01:02 AM |
how to add a second x axis with same Y axis value in one plot | Mike | Charts and Charting | 1 | October 19th, 2005 08:42 AM |
New question about lookups | Don Sealer | Using Forms | 3 | December 24th, 2004 04:44 PM |
P & V chart: Secondary X axis gradient (again) | wlotto | Charts and Charting | 9 | March 15th, 2004 05:26 PM |