• 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.

Sentiment trend chart

Status
Not open for further replies.
A11 Mighty

A11 Mighty

Member
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 :
84396
Any help is much appreciated.

Cheers,
Mighty
 

Attachments

  • 1686582915425.png
    1686582915425.png
    50.1 KB · Views: 3
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.
 
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.
 

Attachments

  • A11 Mighty something like.xlsx
    15.2 KB · Views: 10
Last edited:
vletm said:
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.
Click to expand...
I though you mentioned there are some server challenges and therefore you were unable to attach the file for the sample you created.
 
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 said:
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.
Click to expand...
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?
84418
 
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
... hmm?
Your sample snapshot shows +22% for January
BUT
Your used formula gives .. 25%.
Isn't there ... three % gap?
 

Attachments

  • A11 Mighty something like.xlsx
    17.5 KB · Views: 22
Status
Not open for further replies.
Back
Top