Missing column from column clustered chart

[FNeeq]

I will be glad if anyone can help me recover the missing column from my column clustered chart. Moreover, how do I get the legend under the title using VBA. Thanks

 

[Domenic]

I will be glad if anyone can help me recover the missing column from my column clustered chart.

See if the following link helps...

Broken Y Axis in an Excel Chart - Peltier Tech Blog

Moreover, how do I get the legend under the title using VBA.

Try...

[I]chart[/I].SetElement msoElementLegendTop

Hope this helps!

 

[FNeeq]

Domenic, thanks for the help. In regards to my first question, I talking about one of the bar not showing up when I add the Line Markers chart. Please see below the chart without the line markers.

 

[Jon Peltier]

Format the horizontal axis, make sure the setting for 'Axis Crosses' or 'Axis Position' is 'Between Tick Marks'.

 

[FNeeq]

Thanks Jon, fixed now.