Charting Issue

[shashi.excelcrazy]

Hi,

I need to show GSA as line to bar chart. (Data Enclosed)

Can someone help me with steps involved.

Appreciate your help guys.

Thanks,

[MrShorty]

I am not sure what you are trying to do or what problem you are having.

The basics of creating a combination chart are easy. Select the desired data series (the GSA series, in this case), and change the series chart type to line. You now have column + line combination chart.

The main complication in your is that your GSA numbers are so much smaller than the others. I am not sure how you want to deal with this issue.
1) You can put the GSA on the secondary axis, but that would mean putting both of the column chart series on the primary axis and changing them to clustered column rather than stacked column. This is probably the easier of the two approaches.
2) You can create a panel chart that will put the GSA series in a separate panel. https://peltiertech.com/Excel/Charts/StackedCharts.html

Is that helpful?