custom scales
 

This is going to be very specific.

I need to create a chart that has 5 labels and 5 Y axis points. However,
each label has it's own unique scale. Also, even though the 1st point has a
different set of intervals but I still want to them to visually be spaced out
evenly. In the examples below point TP has a range of 1-210 and SP is 236-350
but I still want them to be visually the same distance apart on the chart. I
suppose I would want to be able to put a custom limit to each individual
section of each labal rather than having 1 set of limits applied to the whole
chart. Is this doable? Also, I'm using a work computer so I can't download
anything that isn't already including with Office 2007. Any help is grateful
even if the answer is no.

Thanks.


Label 1
TP < 210
SP 211 - 235
CP 236 - 350
IP 351 €“ 375
UP 376

Label 2
TP < 205
SP 206 €“ 220
CP 221 €“ 330
IP 331 €“ 350
UP 351

custom scales
 

Hi,

Try this site:

http://peltiertech.com/Excel/Charts/ChartIndex.html

Take a look at the topics under the heading "Axes - Custom Axis Scales using
Dummy Series"
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Angelsnecropolis" wrote:

This is going to be very specific.

I need to create a chart that has 5 labels and 5 Y axis points. However,
each label has it's own unique scale. Also, even though the 1st point has a
different set of intervals but I still want to them to visually be spaced out
evenly. In the examples below point TP has a range of 1-210 and SP is 236-350
but I still want them to be visually the same distance apart on the chart. I
suppose I would want to be able to put a custom limit to each individual
section of each labal rather than having 1 set of limits applied to the whole
chart. Is this doable? Also, I'm using a work computer so I can't download
anything that isn't already including with Office 2007. Any help is grateful
even if the answer is no.

Thanks.


Label 1
TP < 210
SP 211 - 235
CP 236 - 350
IP 351 €“ 375
UP 376

Label 2
TP < 205
SP 206 €“ 220
CP 221 €“ 330
IP 331 €“ 350
UP 351