Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scaling within a chart
I have 3 series of data; 1. A total figure (1500-2500) and two series of
percentages (0-100%). I would like to show them all on the one chart but the scale sits far too hight to see the percentages and they just look like straight lines. Is it possible to have two different types of figures that are numerically far apart scaled down to assist in reading? Any help would be appreciated. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scaling within a chart
Yes, right-click one of the series, Format Data Series/ Axis / and select
secondary axis. -- David Biddulph "Oliver S" wrote in message ... I have 3 series of data; 1. A total figure (1500-2500) and two series of percentages (0-100%). I would like to show them all on the one chart but the scale sits far too hight to see the percentages and they just look like straight lines. Is it possible to have two different types of figures that are numerically far apart scaled down to assist in reading? Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating a Chart object | Charts and Charting in Excel | |||
Scaling a chart that has been dynamically created in vb | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |