Chart help

[Abedh1]

please i need some help in this!
Thanks in advance

[Abedh1]

The red line is a separator, but i need it in the graph too

[Andy Pope]

Here are a couple of ways.

Change the layout of your data slightly.
After moving Totals to secondary axis add secondary horizontal axis.

first chart simply changes position of secondary axis

second chart uses secondary vertical major gridline

[janimani]

Could you give us an idea of what data you're recording. Just a sample workbook with column headers and some dummy data would be great.

[Abedh1]

Thanks a lot Andy it's great! that's the same thing i want! if you please can explain a bit how you did it ( the steps) i will be great full.

[Andy Pope]

There are instructions in my post.

If you really need more detail you better tell us which of the 2 methods you prefer

[Abedh1]

The second methods, i'm a beginner in Excel so it's a bit annoying .
Thanks Andy for your help.

[Andy Pope]

Select range C24:P28 and create clustered column chart.

move both Total series to secondary axis
use ribbon Chart Tools > Layout > Axes > Secondary horizontal axis, to apply secondary horizontal axis.
Format the new axis,
Interval between tick marks = 12
Axis Labels position = None
Major Tickmarks = None
Line Color = No Line

Format Secondary vertical axis, Horizontal axis croses Automatic

Apply Major Vertical gridline to secondary axis. Format gridline to red

[Abedh1]

done, Thanks Andy