Alternate Axis

[#1]

Hi All,

How do I show  values in x or y-axis (like 1, 3, 5 etc.,) for Order ID. When I use Static Step as 2 it is showing up as (2, 4, 6 instead of 1, 3, 5). I want to see all the 5 rows populated but only scale for the axis as 1, 3 and 5

Below is my sample data.

Thanks

VJ

[swuehl · Accepted solution]

Maybe like this using a calculated dimension:

=If(Odd([Order ID]), [Order ID], Dual(' ',[Order ID]))