Forum Discussion
X Axis Showing Arbitrary Value
Hi All -
After upgrading my desktop environment yesterday, my bar charts are adding in an arbitrary value to the X Axis. I'm looking to map very simple Numbers of Approval Requests (Value) by Approval level (Axis). I only have data for, and would only like to show, Levels 0, 1, 2, 3, and 5. For some reason there is a 3 being added to my axis with no data and I am not sure how to remove. You can see from the image below that the there is no 3 in my data, so I cannot filter out.
I wasn't able to find anything in my previous forum search - would anyone be able to assist?
thanks!
Katrina
Hi katt ,
This is related with the type of column you have (number) and the x-axis formatting, when using numbers or dates by default the axis are made has continuous starting in at your minimum and ending on your maximum, so everything else in the middle is filled out if you change the axis to categorical you will get the correct values:
Just to give you an example I have made a sample column with only two values 1 and 5 has you can see the continuous fills out the rest:
Top is continuous, middle is the table with the actuals values bottom is categorical.
Hope this helps.
