Chart Labels

3.57K viewsGeneral Discussion
0

Ok, I have a chart where there are two categories on the right. The name of both catagories are included in the data series label, and I would like just the name of the bottom catagory to be used. Is there a way? Tks.

Carl

0

Hey Carl,

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.

-Mike

0

Mike,

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.

Carl

0

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!

-Mike

0

Ok, here it is again. The chart is called ‘Housing Oversupply – Chart 1’. Mike, please let me know if you can’t see it. Tks.

Carl

0

Hi Carl,

I didn’t see a chart view in the attached model. Could you verify and reattach a model with the chart you are looking to modify?

Thanks,

-Mike

0

On a related note, what if I really need to share a chart with a non-quantrix user. I see that there is no option to export the chart in Excel format. Is there a way? Tks.

Carl