Number column as x axis for bars graph

[peng wangParticipant]

Hi,

I would like to know how to add a number column as x axis for bars graph (Type X Area %). I only find the labels for a column, but I have a lot of rows, the numbers overlapped and the ticks dissapeared. I have to delete many numbers in the column (as label), But it looks tedious and the ticks also doesn’t shows in the graph.

 

Stay health and best wishes,

Peng

[peng wangParticipant]

The default x axis is the number of rows, I don’t want to use it as x axis.

• This reply was modified 3 years, 6 months ago by peng wang.

[peng wangParticipant]

• This reply was modified 3 years, 6 months ago by peng wang.

[dgteamModerator]

Try adding a Uniform stride in the Axis settings.   Does that work for your case?

[peng wangParticipant]

It doesn’t work. The x axis shows the row numbers, not the number from specific column.

[peng wangParticipant]

[peng wangParticipant]

I got an idea to achieve it, create 2 column as the location and labels, but I think it is not convenient way, and I hope you can add a new function for using a column as x axis of bars command. 

[Author]

Posts