ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Scaling within a chart (https://www.excelbanter.com/charts-charting-excel/117241-scaling-within-chart.html)

Oliver S

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.

David Biddulph

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