CODEWITHSUNDEEP
excelvbacharts
Martin M.
Martin M.

Reputation: 43

Daily plot report Axis Formatting

I am plotting the data of one day. I get the values from a CSV file. One column is the time hh:mm:ss and the other my data. I plot a XY - Chart. For all of this I am using VBA.

The chart should always start at 00:00 and end at 24:00. So I set minimum to 0 and maximum to 1. But the axis now have values from 00:00 to 00:00. I played around a little bit but can't find a solution for this

Upvotes: 2

Views: 25

Answers (1)

Siddharth Rout
Siddharth Rout

Reputation: 149325

The problem is 00:00:00 is the same as 24:00:00. You need to format the chart axis to 24hr format

Try this. Amend as applicable.

ActiveChart.Axes(xlValue).TickLabels.NumberFormat = "[h]:mm:ss"

enter image description here

Upvotes: 1

Related Questions