Sunset - end of summer Excel chart

posted Sep 1, 2013, 12:47 PM by Krisztina Szabó   [ updated May 22, 2014, 1:48 AM by r ]
[Dr. Frankenstein leans in for a kiss]
Elizabeth: Taffeta, darling.
Dr. Frederick Frankenstein: Taffeta, sweetheart.


by The FrankensTeam

At the end of summer… remembering the sunshine… sizzling… the beautiful sunsets…
then… a chart was born.


Sometimes in forums we have seen a request for this kind of chart. It is not difficult to put it together using the universal xy scatter chart to draw the lines. The trick in the solutions is how to add labels. Regarding the fact that every second xy scatter point is at the center of the circle, pie chart is the simplest way for positioning data labels: no need to assign the label cells one by one to the scatter points. This way the chart is fully dynamic - you can add new data to the table, it will automatically appear on the chart.
You can download the file.