Graph with Bars (Ranges) & Lines

SHardin

New Member
Joined
Oct 30, 2019
Messages
1
Hello,

How would I go about making a graph which plots a number of bars (representing ranges) and lines on the same graph as per below:



I would like the lines (which represent the 5th and 95th percentiles of the ranges) to intersect the range as shown in the image.

Any ideas?
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Watch MrExcel Video

Forum statistics

Threads
1,100,142
Messages
5,472,754
Members
406,835
Latest member
steve43040

This Week's Hot Topics

Top