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.

made in gnumeric, should alike in excel


Comments

Popular posts from this blog

java.util.scanner - How to read and add only numbers to array from a text file -

rewrite - Trouble with Wordpress multiple custom querystrings -

php - Accessing static methods using newly created $obj or using class Name -