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. |
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. |
All times are GMT +1. The time now is 02:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com