Brilliant using #. loved the video, taking my notebook into work so I can rewatch some parts to do this sliding scale. All my years as an analyst I have never had to do anything like this but yesterday my boss asked, I said anything is possible. Thank you for sharing. After creating several sliding scale charts and changing the axis order for the text I noted the "Score" didn't change inline with the axis so I ended up doing a mapping table for each of my scores. Looks great when printed :-)
Thats so great! Using the right visual can make all the difference when we are trying to display our data. I am always trying to show a variety of different options for putting together reports that are functional and useful.
Great video and thanks for creating your examples. I have an issue trying to replicate this and can't find where i am going wrong. Would you be able to help me???
GREAT video. I'm about to try it out, but do you know if this works with a scale that isn't numbers, like a status? I want to show what status certain projects are in, ex. Yet to Start, In Planning, etc etc. I'm gonna try to use numbers and relabel the axis, but wondering if you know of any other way. Thanks again for the awesome excel video.
I'm trying to do this with a single bar graph and i'm getting stuck on the secondary axis. is this possible with 1 individual graph instead of multiple?
I have the same thing for work with 9 points. My problem is that the first two variables have a different scoring mechanism. One starts at 67.7 and ends at 16.2 and the other starts at 67.6 and ends with 21.2 All the rest are from 0 to 100 ... I cannot seem to be able to integrate the first two variables. Can you help with that please.
@@DSMStrength it wont be beneficial because the cut off points are different. 0 = 67.7 and yet it is the maximum value .. so it is like the marker has to move backward
Thank you, this is a very helpful approach and very easy to follow.
no problem thanks for watching
Brilliant using #. loved the video, taking my notebook into work so I can rewatch some parts to do this sliding scale. All my years as an analyst I have never had to do anything like this but yesterday my boss asked, I said anything is possible. Thank you for sharing. After creating several sliding scale charts and changing the axis order for the text I noted the "Score" didn't change inline with the axis so I ended up doing a mapping table for each of my scores. Looks great when printed :-)
Thats so great!
Using the right visual can make all the difference when we are trying to display our data. I am always trying to show a variety of different options for putting together reports that are functional and useful.
Great walkthrough, very specific and easy to follow
Great video and thanks for creating your examples. I have an issue trying to replicate this and can't find where i am going wrong. Would you be able to help me???
Great video, excellent explanation. Keep it up.
Wow this is great for colour development of apples thank you so much!!
that is an interesting use case!
Any chance you can upload the file?
GREAT video. I'm about to try it out, but do you know if this works with a scale that isn't numbers, like a status? I want to show what status certain projects are in, ex. Yet to Start, In Planning, etc etc. I'm gonna try to use numbers and relabel the axis, but wondering if you know of any other way. Thanks again for the awesome excel video.
just assign each one of those a number and display accordingly
I'm trying to do this with a single bar graph and i'm getting stuck on the secondary axis. is this possible with 1 individual graph instead of multiple?
im not sure i believe it should be
I have the same thing for work with 9 points. My problem is that the first two variables have a different scoring mechanism.
One starts at 67.7 and ends at 16.2 and the other starts at 67.6 and ends with 21.2
All the rest are from 0 to 100 ...
I cannot seem to be able to integrate the first two variables. Can you help with that please.
Convert to a score out of 100
(Max-min) / (x-min) x 100
@@DSMStrength it wont be beneficial because the cut off points are different.
0 = 67.7 and yet it is the maximum value .. so it is like the marker has to move backward
@@mhmdsurvivor use data label to make it show value you want.. or make a separate graph for those values
If I sent you an excel spreadsheet could you format the data into a slide scale?
It depends,
if it is something quick that I can help you with then for sure. Otherwise I may need to charge.
can this be done in google sheets?
I do not believe so