View Single Post
  #15   Report Post  
Old October 14th 20, 08:44 AM posted to microsoft.public.excel.programming
Max[_9_] Max[_9_] is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2017
Posts: 20
Default X Y Scatter Excel Graph X Axis Customization

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