charts with time issues

[excel.vba]

I am facing the issue of including time in excel charts as the y axis.


Jan Feb Mar Apr May Jun
A 109 114 137 145 135 201
B 23:19 23:24 23:47 23:55 23:45 0:51
C 23:19 23:24 23:47 23:55 23:45 0:51

Basically, when i jump from May to Jun for B and C, I need the chart to continue on an upward trend instead of dipping back.

I am not sure how to attach the excel file. Please let me know how to do so so that i can attach it to make things clearer.

Thank you!

 

[Robert Mika]

Yo can not attached a sheetdirectly but you can useL

HTML Maker
or
Excel Jenie
to post your data.
Alternatively you can upload youe spreadheet into nay of external website.

 

[Jon Peltier]

This reply may not make sense, because I'm not sure what the times signify, and why each month has a particular time associated.

A time is a fraction. If you go from a large fraction (almost=1) to a small one (just over zero) of course it's going to return almost to zero.

Instead of time, enter date and time in the cell Since June 1 is 1 greater than May 31, any date+time on June 1 is greater than any date+time on May 31. Format the cells to show only the time and not the date if necessary.

If you have a cumulative time, not a tame on two successive days, then simply add 1 to any times after the dip (ad add 2 after the second dip, etc.).

P.S. If your description is clear, you don't need to upload your worksheet. If you had uploaded one I would not have taken time to respond to this post. It takes too long to open and figure out a workbook. Even a screen shot is not necessary in the vast majority of cases.