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

Thanks,
Max

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.

https://1drv.ms/x/s!Ak16zOG3Op0Cb05b...Azh9M?e=lyklCG

Max