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

Question

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 !

Paul Chang · Answer

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!

Andrey Khaneev _StiltSoft_ · Answer

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

Andrey Khaneev _StiltSoft_ · Answer

Hi Paul,

You can set only fixed x-axis step.