View Single Post
  #4   Report Post  
Old October 8th 20, 10:59 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 Thursday, 8 October, 2020 at 10:41:04 am UTC+5:30, Max wrote:
On Wednesday, 7 October, 2020 at 4:32:54 pm UTC+5:30, Peter T wrote:
"Max" wrote in message

I am trying to Plot X Y Scatter Graph where I want to change the X Axis to
Text i.e. Single Hook, Double Hook, Triple Hook..... ETC while the Y Axis
can be 0, 50, 100, 150..... By Default X Axis takes 1,2,3 .... Can I Chage
to my Desired Lable?

Please LEt me Know If the Same is Possible.

My Data is as Under.

Mooring Type Single Hook 2 Hook 3 Hook 4 Hook
extreme loads benign locn 110 132 198 264
extreme loads exposed locn 110 165 253 341
accidental load condition 129.8 231 308 385


Are you sure you want a Scatter chart rather than a Lines, or even a
standard Column type?

Peter T

Thanks Peter, YEs I am just tring to Plot a X Y Scatter Graph only where I wanted to change the Axis (Perticularly X Axis) to show the Text Format.

Please find attached link for the file where I can explain easily.!Ak16zOG3Op0Cb05b...Azh9M?e=lyklCG