View Single Post
  #2   Report Post  
Old October 7th 20, 12:02 PM posted to microsoft.public.excel.programming
Peter T[_8_] Peter T[_8_] is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2019
Posts: 64
Default X Y Scatter Excel Graph X Axis Customization

"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