'Text' X- Axis for a Scatter Chart?

[mwallman]

Hi all,

Is there a hack of some kind to create Text based X-Axis for a Scatter Chart?

I have tried numerous things like holding a text field as Dual and then using the field that way but it does not work.

If I put a 'ID' field for the Text values it works but I really want to show the actual names rather than an ID.

A workaround is using Line Graph with dots but then I cannot change the size of the bubbles like a scatter graph can with the third expression.

Does anyone know how to get a scatter chart to show text values in the X-Axis please?

[swuehl]

Have you looked into using a Grid Chart instead?

[mwallman]

I have tried that swuehl but it doesn't spread out the values proportionatly like a scatter graph does. It's very 'grid' based rather than free like a scatter graph.

[MarcoWedel]

Hi,

your x axis only having discrete values I guess you're talking about a continuous y axis.

What kind of data are you getting for this?

Can you post a sample?

Maybe you could precalculate equidistant values to get a nice scale there?

hope this helps

regards

Marco

[mwallman]

Hi Marco attached is an app with an example of what I am trying to achieve.

[swuehl]

It's strange that you can use CompanyName as X-axis expression here.

I believe both axis expressions need to return numeric values, that's the property of a scatter chart, as you said, showing two continuous numeric axis (in contrast to a grid chart).

If you remove the (optional) expression for z-value, your chart won't render, and you also see that the axis use the second and third expression, so I think what's happening is that QV skips CompanyName as x-axis expression and takes second and third as axis expressions.

I am not really sure what you are trying to achieve, since IMHO, text labels on x-axis won't make the chart really useable, given that the axis is numeric continuous, right?

[MarcoWedel]

Hi,

maybe you could use pop up texts an labels on datapoints instead of the company names on the x axis and sort by rank instead of a (quasi random) alphabetical order:

or simply use a bar chart?:

hope this helps

regards

Marco