Graph with Bars (Ranges) & Lines

S

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?
R7P9YZp
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
You must log in or register to reply here.

Similar threads

R
  • Question Question
Adding Multiple Vertical Lines on Horizontal Bar Chart
Replies
1
Views
806
NdNoviceHlp
NdNoviceHlp
pbornemeier
  • Question Question
VBA Hangs While Producing Complex Graph
Replies
1
Views
358
frabulator
frabulator
D
  • Question Question
Plotting results of tests on a graph as points on a bell shapes curve. Each test result needs a confidence level attached to it.
Replies
0
Views
286
Dennis64
D
L
  • Question Question
I need help with a spreadsheet I have made for "ongoing project Timeline"
Replies
1
Views
657
sparky2205
sparky2205
S
  • Question Question
Trendline values using Dynamic Range in Excel - comparing with LINEST function
Replies
1
Views
1K
Domenic
D

Forum statistics

Threads
1,225,730
Messages
6,186,698
Members
453,369
Latest member
positivemind

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top