Sentiment trend chart

[A11 Mighty]

Hello -
I've been looking in the forum with not much success. was hoping to see in anyone has a template or can help provide instructions on how to create a sentiment trend chart. Something like what's shown below :

Any help is much appreciated.

Cheers,
Mighty

 

[vletm]

A11 Mighty
Is that line with markers correct?

 

[A11 Mighty]

Hello @vletm -
That's an example I found online. Didn't verify the data. Looking closely at the data, I believe there are a few months where it should go below the 0 since the units for the current year are below the previous year.

 

[vletm]

A11 Mighty
Of course, Something like what's shown below can create.
... including that gray line.
But just now, there are some Server challenges ... and I cannot attach file.

A11 Mighty
Updated ... just now - Chandoo.org's server seems to allow attach file.

 

[A11 Mighty]

@vletm Thank you, your help is much appreciated

 

[A11 Mighty]

Hello @vletm Any luck with uploading the sample you have ? Thank you

 

[vletm]

A11 Mighty
.. luck?
As You've noticed - or have You got something someway?

 

[A11 Mighty]

A11 Mighty
Of course, Something like what's shown below can create.
... including that gray line.
But just now, there are some Server challenges ... and I cannot attach file.

I though you mentioned there are some server challenges and therefore you were unable to attach the file for the sample you created.

 

[A11 Mighty]

Hi @vletm - Just a follow up to see if you are able to help recreate the sentiment trend chart view, similar to what I shared. Any help is much appreciated. Thank you

 

[vletm]

A11 Mighty
As I've replied,
A server error occurred. Please try again later.

 

[A11 Mighty]

@vletm Understood. Seems like there are some issues with Shandoo server and being bale to upload document. Thanks you!

 

[A11 Mighty]

A11 Mighty
Of course, Something like what's shown below can create.
... including that gray line.
But just now, there are some Server challenges ... and I cannot attach file.

A11 Mighty
Updated ... just now - Chandoo.org's server seems to allow attach file.

Thank you so much @vletm I really appreciate your help here. Is there a way to add a percentage to the line as shown below?

 

[vletm]

A11 Mighty
It's possible to add those too ...
... especially, after You know/find out - how to get those two values?
... as well as You've verified that those values have to be there as You have added there.
... do You expect to get those arrows too?

 

[A11 Mighty]

Hi @vletm
I used this formula

I don't need the arrows. It was more a way to point out the % values .
Thank you

 

[vletm]

A11 Mighty
... hmm?
Your sample snapshot shows +22% for January
BUT
Your used formula gives .. 25%.
Isn't there ... three % gap?