You want to draw a column chart with two data series and one you want to make a primary and one you want to make secondary.
Below, you have drawn a normal column chart in first chart. The second series (orange one), you have converted to secondary axis. Now, it has overlapped the first series. You have tried all options to adjust Series Overlap and Gap Width but still first data series is not visible.
If you want to overcome this, read on…..
1. Right Click on Chart > Select Data > Add
Give a name to this series, let's call it Dummy1.
Put a value large enough in Series Values: box. The default populated is ={1} which you can make to ={80} for my case. The purpose is to make this series visible. Hence, you need to choose this value appropriately.
2. Now, right click on Dummy1 > Format Data Series > Primary Axis
3. Right Click on Chart > Select Data > Edit Dummy1. Put ={0} in Series Values: box
4. Move Dummy1 to between our original two series.
5. Add another series with name Dummy2 and put ={0} in Series Values: box.
6. Move Dummy2 to after Dummy1 and before Sales2.
7. Now, delete Dummy1 and Dummy2 from your legends.
You have a perfect looking column chart.
