Scatter chart - problems replicating chart layout

[sbirov]

Hello everyone,

I really want to replicate a layout of a chart I found but I can't do it alone. The chart represents some subjects that are rated using a Likert scale (5 points) and 2 participants's answers are compared.

A link to the file with the image and my draft is attached:
File-Upload.net - sb.xlsx

I'd appreciate any help you can provide.

Best regards,
sbirov

 

[Steve=True]

Hi Sbirov,

Check out this post and see if it is an easier way for you than doing a xy scatter line:

Using the Camera Tool to Create a Vertical Line Chart in Excel:
How-To Make a Vertical Line Chart Using Camera Tool in Excel | Excel Dashboard Templates

On a side note, why does it need to be vertical? Can you not just do a regular line chart and get the same information?

Let me know what you think.

Steve=True

 

[Steve=True]

Hello again,

You inspired me to create a blog posting demonstrating another technique to create this Excel Chart. You can see the chart step by step tutorial and video demonstration here:
[h=2]How-to Make an Excel Vertical Likert Line Chart with Categories[/h]
How-to Make an Excel Vertical Likert Line Chart with Categories | Excel Dashboard Templates

There is also a file download for your use.

Please let me know what you think.

Thanks

Steve=True

 

[sbirov]

Omg Steve this is ridiculous! Thank you so much, I'm literally tearing up a bit that you took the time to find a solution and describe it so well, not everyone would make such an effort. I was hoping that there is a "standard" way to do this without using the camera tool and you found it...
Thanks again and keep making users happy

sbirov

 

[Steve=True]

Thanks for the awesome feedback. I am so glad the tutorial worked for you.

Steve=True