Display only actual value in the bottom x-axis on chart from table

We use chart from table macro to display table data.

The data is based on each svn revision number, which is in the 1st column of the table.

The svn revision number is ascending but can have different interval among them.

i.e. 4000, 4001, 4100, 4101, 4120, 4140, etc.

We use this number as x axis value in line chart and we want to only see actual value

shown in x axis, not the fixed number interval like 4000, 4200, etc in bottom x axis.

Is there a way that can achieve this purpose? or using another macro?

Thank you !

1 answer

0 votes

Hi Paul,

You can set only fixed x-axis step.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Or you can use Column / Bar chart type instead of Line chart type.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Thanks for the info.

x-axis value shown in Column chart is what I expect.

But seems the latest value is displayed in left side - from right to left direction.

is this feature for Column chart?

Looks like x-axis value in line chart cannot look like those in Column chart. True?

Thanks!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.