Hi,
I am trying to show trend analysis of bad feedbacks received from our customers. I have tried line, bar, etc.. graphs and found this was the best way. But I am looking forward for any suggestions on representing this in a better way.
Thanks.
Helping you do a better job processing, analyzing, sharing, and presenting your data.
Stacked column chart and custom Y-axis
There look like a lot of ways to slice this data, so rather than going for one perfect chart, you may be better to offer multiple views depending on the stakeholder who’s making the decision. With your existing view, I’ve tried a horizontal bar chart (makes the categories easier to read for me) with a total/breakout split and an actionable title. Hope this gives you some ideas for a few more layouts.
Attached image:
Hey – this caught my eye & I did a quick sketch but only off the visualisation you posted – I’ve haven’t look at your data in any detail (where something else might have caught my eye) – anyway, I hope this might be useful – I did it in Excel because I thought that might be practical.
I basically want to make it easier to read vertically & horizontally – it could do with a little further work: I might do more to distinguish the categories or to group them a bit more clearly – maybe with colour
https://ktglbuc-my.sharepoint.com/personal/tobias_sturt_graphicdigitalagency_com/_layouts/15/guestaccess.aspx?guestaccesstoken=TOzwOFpDeCBvT8Zp2iVCMqSPD5WZD%2fpRRNTBt%2bAdr4E%3d&docid=1b481502b5d704f0db47925fd78dec838&rev=1&expiration=2017-01-07T10%3a07%3a51.000Z
Attached image:
One second attempt. Including monthly and category totals
Hi Ira,
Can you guide me on how to go about achieving this output?
Is it on Excel or some other tool? Thank you.
These are 3 separate excel charts grouped together. Upper left is a clustered column chart. Lower left is a stacked column chart with dummy (no color filling) series added to produce the spacing. Lower right is a plain clustered bar chart. Major unit for scaling is 5. There is not a lot of work into it. Just some sizing and scaling. Thinking it over, i wouldn’t rank the feedback categories. That’s all.
Hi,
As a quick suggestion: I would keep the chart type but would make some tweaks: sorting the feedback items from highest # of total respondents to lowest, would eliminate the grid-lines and left axis since you already have labels for everything and would underline total figures more than other labels. Maybe change the color choices as well.
Attached image:
I would do a facetted heat plot. This was done in R + ggplot2 and I can share the code if it is of interest.
Attached image:
Hi there,
I think you need to split this visualisation and try to frame your issue. If you’re trying to visualise everything you won’t be able to highlight anything. Also I think that not all your data are meant to be visualise on a time line.
Not saying I’m right but that might give you some idea !
This is awesome. Thank you so much for the valuable suggestions. I was kind of mind blocked and never thought there could be so many ways.
Truly appreciate everyone’s time here.
Thanks
Manish Khemka.