Values on Line Chart: displaying on limited number of data points only

[vlad_komarov]

Hello!

I would like to receive an advice or suggestion how to handle a requirement I have:

1. I have ~2+ years of data (per month) and I have to display it on the line chart with Trellis.

2. The chart itself is pretty small, but I need to display values on data points (percentage, with up to 2 decimals)

3. Having all data displayed produces pretty bad result:

Of course, selecting limited set of months produces better results:

But I have to display full data set most of the time.

I would like to know if it possible to control number of points to have values displayed (in version 9).

For example, one number displayed for every five data points...

And it would be ideal if I can change this number depending on the months range selection....

I would appreciate any suggestions.

Thanks!

Vladimir

[fernandotoledo · Accepted solution]

I think you can do it in object properties / Presentantion. I try to avoid using labels over the datapoints. Take a look at Stephen Few ´s articles about it!

regards

fernando

[vlad_komarov]

Thanks for reply, Fernando

The option in Properties is not allowing me to display numbers the way I want.

It just hides all values if total number of points if more than selected in properties.

The only improvement I was able to achieve is to display numbers vertically, but it will not help much. Which Stephen Few's article you are talking about? "Data Visualization for Human Perception"?

Please let me know.

VK

[vlad_komarov]

Adding the following to the Expression's "Show Value" option will allow to display every other value point on the chart:

=if(mod(RowNo(), 2)=0, 1, 0)

Please note that "Values on Data Points" option should be disabled for that Expression.

VK