View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Max[_9_] Max[_9_] is offline
external usenet poster
 
Posts: 20
Default X Y Scatter Excel Graph X Axis Customization

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.