scroll through dynamic 0-24 hour time format xvlaues

[baroony]

i am working on dynamic chart showing hourly data (1-24 format) and i want to scroll tgrough data on specified time span like 5hour,there is times that .minimumscale is greater than .maximumscale property on chart (cht.chart.axes. ...)and scroll has problem( for example when time span is between 23 to 3. how to fix problem

 

[Gerald Higgins]

Hi, welcome to the board.

Your request is a bit vague, we have no idea what your source data looks like.

But perhaps consider setting up your data so that, for example, 03:00 on Day 1 is identified differently from 03:00 on Day 2 - so have a schedule that covers perhaps 48 hours.

OR, consider something that says something like
IF endtime < starttime
build the selected data in two sections, first section from start time to midnight, second section from midnight to end time.

 

[baroony]

Hi, welcome to the board. Your request is a bit vague, we have no idea what your source data looks like. But perhaps consider setting up your data so that, for example, 03:00 on Day 1 is identified differently from 03:00 on Day 2 - so have a schedule that covers perhaps 48 hours. OR, consider something that says something like IF endtime < starttime build the selected data in two sections, first section from start time to midnight, second section from midnight to end time.

how to set data like 03:00 on Day 1 is identified differently from 03:00 on Day 2

 

[Gerald Higgins]

I don't really understand your question.

It would probably be best if you can post a small sample of your data, including some entries that go over midnight, and some that don't, and explain what exactly you want the results to be.

 

[baroony]

'part of macro ,d28 d29 updated with scroll
' rng is time vector hour basis
' operator records data every hour and we have large data for some years
' i want to scroll through data and user specify time span of chart
With cht.Chart
.ChartType = xlXYScatterLines
.HasAxis(xlCategory) = True
.Axes(xlCategory).MinimumScale = rng(sh.Range("d28").Value)
.Axes(xlCategory).MaximumScale = rng(sh.Range("d29").Value)
End With

 

[Gerald Higgins]

I'm afraid that doesn't help me at all.

It would probably be best if you can post a small sample of your data, including some entries that go over midnight, and some that don't, and explain what exactly you want the results to be.

Can you do this ?

 

[baroony]

i use trick, i set x-axis values showing false,
,add extra line(k) with values equal to zero(instead horizontal axis),and then add costum
labels through: cht.Chart.SeriesCollection(k).DataLabels(j).Text