Setting Y Axis to text on horizontal bar charts
I'm using a Horizontal bar chart and would like to set the "XType" value to 1 (numeric) but on the Y axis.
Setting XType to 1 normally allows the bars to be spaced apart based upon the x values. Changing the XType to 1 on a horizaontal bar chart puts all the bars in odd, random locations. When I try to set "YType" I get an access violation.
What is the fix?
ETA: Fixed it. Put the variable spaced values as YSource and the bar lengths as XSource, then Set XType to 1. Not sure why it didn't work before.
Setting XType to 1 normally allows the bars to be spaced apart based upon the x values. Changing the XType to 1 on a horizaontal bar chart puts all the bars in odd, random locations. When I try to set "YType" I get an access violation.
What is the fix?
ETA: Fixed it. Put the variable spaced values as YSource and the bar lengths as XSource, then Set XType to 1. Not sure why it didn't work before.