Secondary axis for stacked column

[Nir Robinson]

Hi all,

I have 7 projects (aaa-ggg) with income and profit for every project - attached file.
I need to make 1 chart that for every project there are 2 columns (income & profit).
My problem is that I didn't succeed to create secondary axis for the profit column.

Thanks in advance,

Nir

 

[NARAYANK991]

Hi Nir ,

Have you checked out this link ?

http://www.exceldashboardtemplates....te-a-stacked-clustered-column-chart-in-excel/

Narayan

 

[Jon Peltier MVP]

Nir -

After creating the chart, select the series you want on the secondary axis, press Ctrl+1 to format it, and choose Secondary Axis. This will tell Excel to add a secondary axis and plot this series on it.