How to create such a gragh?

[EkaterinaM]

Hi everyone!

Maybe you can help me, how should I create such type of graph?

[MrShorty]

Your picture looks to me like a line chart with a multi-level category axis and two data series.

1) Arrange data in the spreadsheet:

Please Login or Register  to view this content.

2) Select this table -> Insert Line chart
2a) If Excel misinterprets the desired source data, fix up the source data in the Select Data dialog.
3) Format both data series to have the desired marker type/size/shade/color and to have no line.
4) Other formatting as desired.

Does that help?

[EkaterinaM]

Thank you so much!!!

I entered data how you recommend, than created a histogram, changed type of histogram for the raw to the line one, and then removed lines)
This is the result

[EkaterinaM]

This is the result

Attachment 731270

[EkaterinaM]

This is the result