Hi There

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

"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

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.

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

"Max" wrote in message
Please find attached link for the file where I can explain easily.

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

Max

I didn't see this when I posted a couple of minutes ago, if that didn't
answer your question let me know and I'll look at your file.

PT

On Thursday, 8 October, 2020 at 4:20:57 pm UTC+5:30, Peter T wrote:
"Max" wrote in message
Please find attached link for the file where I can explain easily.

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

Max
I didn't see this when I posted a couple of minutes ago, if that didn't
answer your question let me know and I'll look at your file.

PT

Peter Thanks for your Reply and solving the trouble....
The trouble I am facing is I am still not able to see the result in the displyed Graph. Its still shows the numbers.
May be the Excel Version. I am using MS Office 365 ProPlus FYI.
Please see the attahed link to seethe result (Screenshot) after adding the first series.

https://1drv.ms/w/s!Ak16zOG3Op0CcBG_..._IrKw?e=VhVLcD

Also updated file is linked below.
https://1drv.ms/x/s!Ak16zOG3Op0Cb05b...Azh9M?e=dnjh65
If you can suggest any workaaround for the same
Many thanks Peter
Max

"Max" wrote in message
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.


Reason for asking is a Scatter works with pairs of X:Y values, but it looks
like your data only has Y values and no obvious reason (based on your data)
to make a Scatter rather than a Line type.

OK, select your 4 hook labels with the single row of values below and create
a Scatter chart. Manually change the Series name to the load label left of
the first row of values. That should create a single series Scatter with
your hook labels on the X-axis.

Manually add the second series:
Select the chart, on the Design Tab / Data / Select Data / Add
Series name: the 2nd 'load' label
X values: the row of 4 hook labels in the top row
Y values: the 2nd row of values

Similarly add the 3rd series

You should now have a Scatter with 3 'load' series and your hook labels as
required on the X axis.

Effectively exactly the same as had you added a Line chart in the first
place, which you could have done simply by selecting all the data as posted
including the labels. Then if visually you only want markers - Format and
remove the lines.

Peter T

"Peter T" wrote in message 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.


Reason for asking is a Scatter works with pairs of X:Y values, but it
looks like your data only has Y values and no obvious reason (based on
your data) to make a Scatter rather than a Line type.

OK, select your 4 hook labels with the single row of values below and
create a Scatter chart. Manually change the Series name to the load label
left of the first row of values. That should create a single series
Scatter with your hook labels on the X-axis.

Manually add the second series:
Select the chart, on the Design Tab / Data / Select Data / Add
Series name: the 2nd 'load' label
X values: the row of 4 hook labels in the top row
Y values: the 2nd row of values

Similarly add the 3rd series

You should now have a Scatter with 3 'load' series and your hook labels as
required on the X axis.



Hmm, I thought that worked but trying again it doesn't, as in the text
labels don't appear in the x-axis. ~(maybe I thought I'd created a Scatter
but accidentally a Line...)

I doubled checked because thinking again I was a bit surprised it worked, As
I mentioned a Scatter requires X:Y values, if the X's are not supplied they
are created by default as 1,2,3 to indicate 1st,2nd,3rd y-value.

I'll look again later and with your file, but it might not be possible,
which'd bring it back to using a Line chart -

Peter T