excel - How do I graph a value for a time range (without repeating time on the x axis) -
i trying graph following information using bar graph:
drift density time 0,23048397 12:00 15:00 0,053393365 15:00 18:00 0,433287679 16:00 19:00 0,129268147 17:00 20:00 0,656067688 18:00 21:00 0,356133746 19:00 22:00 0,083351634 20:00 23:00 0,167938106 21:00 00:00
the values on first column = y-axis
12:00 - 15:00 first value on x axis plotted against y-axis value 0,23048397 (as bar).
the problem is: don't want next y-axis value 0,053393365 (as bar) represent 15:00 - 18:00. why? because time '15:00' show twice.
in other words, have managed x-axis be:
12:00-15.00 ... 15:00-18:00....18:00-21:00
how can make 2 of x-axis 3 hour intervals share 1 common hour?
12:00-15:00-18:00-21:00 (and have pertaining y axis values side-by-side each other?)
i hope description wasn't complicated. of great help!
i don't think there way want in portable manner (i.e. without creating box of names , adjust position , size) using excel alone. can similar effect via appending hyphens first time column (see screenshot - made in gnumeric, should alike in excel). solution not scalable, meaning have adjust width of plot and/or font of labels decrease distance between labels minimum.
if one-time task, i'd correct labels in vector image editor.
if have produce such plots on regular basis or massively, i'd take of tools/libraries plotting, capable of producing svg-files, , adjust labels tiny script (or integrate them in small program or using pipes).
it be, there ready-made
r
'ish solution, i'm not aware of it.
Comments
Post a Comment