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
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
- Go to the
Select Data
dialoge box for the chart - click
Hidden and Empty Cells
- Change
Show empty cells as
toConnect data points with line