Forum Discussion
How to structure data in a graphic
I am working on datasets from surveys. I would like to create is a value-map. Like the image below. I wonder which function in use to get the graphics like the image shows. It looks like an NPS. Any tips and advice whom to structure the data to the right function in Excel?
2 Replies
It can be approximated by creating a line chart. But it will be rotated 90 degrees, and coloring the area between min and max is not possible.
Here is a much simplified example with some totally made up, random data. No resemblance to real data is intended.
Sample workbook attached.
Thanks Hans, for your tip, I will start testing this tomorrow with your ideas. HansVogelaar
