excel - How to plot columns on a chart when one column contains large values and the others small -

i want make bar chart in ssrs , table contains multiple columns. 1 column contains large values on 100 while others contain values between 1 , 10. other columns pressed large columns. multiplied other columns values 10 not sure if right way make them visible. please suggest.

if can away multiplying 1 value factor makes sense this. depending on trying achieve, consider having larger values columns , smaller values marker on secondary axis. step step guide below, assuming have current column chart created.

1. right-click on 1 of columns of smaller valued data set on chart
2. select change series chart type.. , change line graph
3. click on new created line
4. on format tab, under current selection grouping, click format selection.
5. in format data series dialog box, on series options tab, select secondary axis
6. still within format data series dialog box, on marker options tab, select style of marker use, fill of marker on marker fill tab
7. under line color tab select no line
8. click close in corner of dialog box

this create chart similar below.