How do I create these kinds of graphs:
with the horizontal histogram counting the number of times the left graphs go through a certain range?
I have access to Microsoft Excel and R.
Create your line chart. Set the Y Axis min and max value. Do not let them be automatic. I set mine to
Create your histogram data. Determine how many bins you want and setup a range for the formulas. I picked 30 bins and so I setup the range
Create your 2D bar chart and format as desired. You may have to set the axis to display in reverse order. I would recommend leaving the axes in place but turning off the tick marks and labels. If you remove it, the plot area will resize and you'll have to manually align it with your line chart. I also reduced the gap between the series but that's mainly a style choice. Edit yours to look like whatever you want. Resize both charts to be the same height and align their top edges.