ExcelBanter - compare small and large figures in one chart

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - compare small and large figures in one chart (https://www.excelbanter.com/charts-charting-excel/65157-compare-small-large-figures-one-chart.html)

duha

compare small and large figures in one chart

how can i compare between small figures with large figures by useing one
chart please?

Bernard Liengme

compare small and large figures in one chart

right click on data series on chart
select format data series
open Axis tab and set Secondary axis
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"duha" wrote in message
...
how can i compare between small figures with large figures by useing one
chart please?

All times are GMT +1. The time now is 08:30 AM.