• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

WAVE GRAPH, do you have a sample?

L

Luciane Coutinho

New Member
My boss asked to do a wave graph, to show 2011-2014 projects win/lost and show the tendency until 2016.
I have no clue how to do it... can you help?
 
Might want to ask the boss to verify, but a wave graph usually refers to a sinusoidal shape. In this case, I'm guessing it shows the up/down of the wins and losses. The tendency could be calculated several ways, but I'll take a guess at a straight linear interpolation. Given that vague description from my boss, this is what I would have produced.

It's a line graph with curved lines. I use a double layer of axis labels to get the years and win/loss labels. Added a linear trendline. Hope it helps!
 

Attachments

  • ExampleWaves.xlsx
    10.5 KB · Views: 17
You must log in or register to reply here.
Back
Top