You will need to turn the labels on the X Axis 90 degrees. First, select the point on the graph where the X and Y axis meet. Then select the other end of the X axis. You will get 2 circles on each end of the axis when it is successfully selected.
Click the ‘Format’ button at the top of the chart view, and click the ‘Chart Axis’ tab. On this screen you will see a setting to change the Label Rotation of the labels on the axis.
Not quite sure if I understand your second question, but if you move the Index Value category to the filter tray, and then select the Index Value Item that represents the Rank (I am thinking this is the NAR item?) you will just get the cities with Rank data in the chart. Please see attached.
Please post again if that doesn’t help.
Thanks for your tips. That did it! In this model, I have another graph where I need to show all data points on the X Axis, because they are names of cities. However, the default setting cuts out some. Can I show them all?
Also, the Y axis data points are actually rankings. But using a bar graph hows accumulations. Is there a way to show a short bar denoting ranking? Tks.
Got it. If you move the ‘Housing Oversupply’ category to the top filter tray – the legend will only show the labels from the ‘Metro’ category. See attached…
Quantrix does not export charts directly to Excel. However, if you select the chart in Quantrix, choose edit > copy view from the menu. Then in Excel choose Edit > Paste Special the chart image will get pasted into Quantrix.
Hope this helps!