How to sort by a column not used in a graph

Question

I am currently working on a turnover graph that displays the projected turnover and YTD turnover rates in a lines and the total terminations per month in bars. The "Month Only + Year" field I have brought it displays Jan-16, Feb-16 and so forth but when I sort them it shows them alphabetically. I have another field called Month but it displays the date and time and I do not want to display that information so I am trying to use the "Month Only + Year" field. When I add the Month field to the graph, it sorts the graph correctly but adds a line for Month since that is where it seems to work the best for the graph but I do not want to display this line.

So is there a way you can hide a line or is there a way to sort a graph by a column that is not used in the graph?

Below is the graph I have currently but DO NOT want the read line to display.

3294318 · Answer

That's exactly what I was looking for. Thank you for the information!

Gianni Ceresa · Answer

Sadly the UI is a bit inconsistent ....

For a chart you must hide the column in the "Criteria" tab (so it will be hidden for all the views), "Column properties" > "Column Format" > "Hide" (a checkbox on the top-right).

3294318 · Answer

Thanks for the response and I will check in the RPD if it doesn't work to hide the month. In OBIEE, where can you hide a column for a graph? I haven't been able to find that in any of the properties.