Missing column from column clustered chart

FNeeq

New Member
Joined
Oct 2, 2014
Messages
15
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 :)

 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

FNeeq

New Member
Joined
Oct 2, 2014
Messages
15
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

MrExcel MVP
Joined
May 14, 2003
Messages
4,851
Office Version
365
Platform
Windows, MacOS
Format the horizontal axis, make sure the setting for 'Axis Crosses' or 'Axis Position' is 'Between Tick Marks'.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,799
Messages
5,446,547
Members
405,406
Latest member
tuxy

This Week's Hot Topics

Top