'Is there an excel function to make a spine chart (Public Health England Profiles)

enter image description here

I am trying to create this kind of range graph (Public Health England is calling it a "spine graph". Is there a way to create this? The website allows us to export a raw data which includes value, lower CI (95.0 limit), upper CI (95.0 limit) for England, Region and local authority.

https://fingertips.phe.org.uk/profile/health-profiles/data#page/1/gid/1938132701/pat/6/par/E12000007/ati/202/are/E09000008/iid/90366/age/1/sex/1/cat/-1/ctp/-1/yrr/3/cid/4/tbm/1

https://fingertips.phe.org.uk/documents/PHDS%20Guidance%20-%20Spine%20Charts.pdf

excel


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions

Reading Excel file with Selenium WebDriver C# and web form with values

How to update an existing row or table of an existing xlsx file using pyexcel for python

Equivalent C# Function For Excels Norm.S.Inv Function

I keep assigning a value to my variable but it stays empty

Excel RTD (Real Time Data) client other than Excel?

Create table from data on a worksheet with specific name and add column

Is it possible to use 'Microsoft.ACE.OLEDB.12.0' provider without installation?

Using VBA to query a SQL Server table in Excel

How to stop scroll bar auto jump in vba

If IsEmpty then go to column A but in same row and extract that data

How can I use a for each loop on an array?

VBA - worksheet object is hidden

Outlook 2010 GAL with Excel VBA

how to read a value from Column Name in Excel in Java

Replace cell value with image