The Computer Oracle

How to have Excel chart connect data points when no value?

--------------------------------------------------
Rise to the top 3% as a developer or hire one of them at Toptal: https://topt.al/25cXVn
--------------------------------------------------

Music by Eric Matyas
https://www.soundimage.org
Track title: Magical Minnie Puzzles

--

Chapters
00:00 How To Have Excel Chart Connect Data Points When No Value?
00:28 Accepted Answer Score 26
00:44 Thank you

--

Full question
https://superuser.com/questions/689312/h...

--

Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...

--

Tags
#microsoftexcel #charts

#avk47



ACCEPTED ANSWER

Score 26


  1. Go to the Select Data dialoge box for the chart
  2. click Hidden and Empty Cells
  3. Change Show empty cells as to Connect data points with line