Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
3 different scales on the Y-axis | Excel Discussion (Misc queries) | |||
Scales | Excel Worksheet Functions | |||
2 scales in 1 chart | Charts and Charting in Excel | |||
scales | Charts and Charting in Excel | |||
Interrupted scales | Charts and Charting in Excel |