How to replace numerics x-axis values with string names on x-axis in graphs.

[Reshu]

Hi all,

I want to put months name or other names on the x-axis of the graphs as shown in the attachment. How can replace the numeric x-axis values with  string names. Can anyone help for the same.

Thanks in advance

[msmeulers]

Hi,

I couldn't find a direct way to put stings inside. But with a graph you are able to work with time stamps. Make only the months of a time stamp visible. You can do that by right clicking your graph: properties: - go to the display format tab, chose the time x-axis

- chose under type (left side under axis pull down) absolute time

- select advanced editing mode

- type the format string %<%B>T

you will only see the months on the X axis.

Hope this helps!

Martijn

[msmeulers]

well: struggled a little bit using a Graph (but that's maybe just me), found a way to create an example based on XY graph. Saved to earlier version so don't mind the lay out.

[ZentronLabsPvt.Ltd]

K.. 

Thanks.

What should be done if I want to put some strings eg:- defect1, defect,2... etc for bar graphs  for either of the axes?

[Reshu]

Also I want to know whether it can be done programmatically?

[James.M · Accepted solution]

I responded to your original thread from a while ago. Use the %<%B>T format for the months. This can be changed programmtically by using the XScale.FormatString property in a property node.

[altenbach]

In the more general case, implementation of this idea would help in the future. Please vote for it. 😄 Thanks!

[James.M]

Up you go!

(It should be noted that even Excel doesn't have this functionality for line/scatter plots)

[altenbach]

---

@James.M wrote:

I responded to your original thread from a while ago. Use the %<%B>T format for the months. This can be changed programmtically by using the XScale.FormatString property in a property node.

---

This assumes that the x-axis is a timestamp and that the markers are aligned with months. Could get complicated. (note that months are not equally spaced in time because they have varying lenght, so there could be surprises)

Implementation of my idea would make things much simpler, because the months axis could just be 1..12, for example (... or 0..11 if you are thinking zero-based :D)

[James.M]

Yup, much simpler. The way to do that right now would be to do some simple timestamp creation to match the month.