On Saturday, 10 October, 2020 at 9:01:05 pm UTC+5:30, Peter T wrote:
"Max" wrote in message
I'm glad that worked and thanks for the feedback. Just one question
though -
what effectively is the difference for your purposes between this
workaround
and simply as a Line chart..?

Peter T

We were having the same graph as horizontle bars erlier as part of our
analysis and reports where may excel graphs are as a part of our
reports...
It's wasa part of report where our end user wanted to have the bars in
Scatter Plot with different markers.
I didn't asked back for the reason to change (I couldn't think any
perticular reson but the presentation purpose).. May be I should.
If it's only for the markers, and maybe not visible lines, the Line type can
be formatted to appear visually same as a default scatter (for this data
with only Y values), and easier to 'combine' Bars with Lines

PT
Ohhh thats added learning ... Peter...
Thanks for the same Idea and sharing the knowledge regarding the linechart can same as a scatter.
Sorry for the late reply as was not well couple of days...
Many Thanks...
Best Regards,
Max