Changing decimal of y-axis of a chart in vba (Excel (macro))

Topic

New Reply

How do I change the decimal place of the y-axis in a chart with vba. right now it is at 2 which is the default, but I want it to be 0 where it just shows the whole number

Thanks Jonathan

Reply | Quote

Replies

If the chart is currently selected:

ActiveChart.Axes(xlValue).TickLabels.NumberFormat = “0”

Otherwise:

ActiveSheet.ChartObjects(1).Chart.Axes(xlValue).TickLabels.NumberFormat = “0”

assuming the chart is the first (or only) one on the sheet. If you have already defined a Chart variable cht:

cht.Axes(xlValue).TickLabels.NumberFormat = “0”

Reply | Quote

Thanks
I tried doing this (cht.Axes(xlDataLabelsShowValue).TickLabels.NumberFormat = “0”) to change the decimal placing of the data labels to 0, but it doesnt work. How would you do that
Thanks Jonathan

Reply | Quote

Data labels are not the same as axes. You have to set the number format for the data labels for a specific series:

cht.SeriesCollection(1).DataLabels.NumberFormat = “0”

or for all series:

Dim ser As Series
For Each ser in cht.SeriesCollection
ser.DataLabels.NumberFormat = “0”
Next ser

Reply | Quote

Thank You

Reply | Quote