View Single Post
  #5   Report Post  
Old October 8th 20, 11:48 AM 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
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