Chart label in round figures

[mandukes]

Hi please have a look at the screen short of the following chart.


What I need is to make labels in round figures so that it may not show up messy and overlapping each other.

Any suggestion would be appreciated.
Thanks


EDIT : Rounding the cell ( column) does not have any effect on labels figures.

 

[VBA Geek]

If you have chosen the "Add Values From Cell" feature then the format should follow that of the linked cells so you can just format those the way you want or you can select the labels and edit the number format in the chart formatting wizard

in any case, you do not need to label each data point in your series, try to label only those that have some kind of relevance or that according to you should stand out

 

[mandukes]

Hi, this chart is created using vba, I need the vba code that would do the same, I want it to round off the values to 2 decimal places without affecting the cell values.

Thanks.

If you have chosen the "Add Values From Cell" feature then the format should follow that of the linked cells so you can just format those the way you want or you can select the labels and edit the number format in the chart formatting wizard

in any case, you do not need to label each data point in your series, try to label only those that have some kind of relevance or that according to you should stand out

 

[stevenjoku61]

Hi please have a look at the screen short of the following chart.


What I need is to make labels in round figures so that it may not show up messy and overlapping each other.

Any suggestion would be appreciated.
Thanks


EDIT : Rounding the cell ( column) does not have any effect on labels figures.

Hey Mandukes,

This might help you. Just make sure the chart is named "Hydraulic Gradient Line" for example

Sub Format_Labels()


ActiveSheet.ChartObjects("Hydraulic Gradient Line").Activate
ActiveChart.FullSeriesCollection("Hydraulic Gradient Line").DataLabels.Select
Selection.NumberFormat = "#,##0"
ActiveChart.FullSeriesCollection("Ground Level").DataLabels.Select
Selection.NumberFormat = "#,##0"

End Sub

 

[mandukes]

Hey there Steven,

Thank you so much for your solution

I have one more question, is it possible to add additional range value in the same graph points?

For example in the second plot (1, 107.6) (8, 107.6) (7,105.6).. so on

instead of the first figures 1,8,7, i need to plot data from a different range : 300, 250,250... so on

So the result should be (300, 107.6) (250, 107.6) (250,105.6).. so on

Regards,
~M

 

[stevenjoku61]

Mandukes,

I believe it can still be done. let me look into it.