Hi guys, I'm working on a project where I have to analyse reviews, gain feedback reviews and produce charts. Let me show you some example data...
<colgroup><col width="64" span="26" style="width:48pt"> </colgroup><tbody>
</tbody>
Please see that this data is for an example of a 4 and a 3* place. We then have number of reviews received per month. For example in March 2013 we received 1 3* review where as in April 2 reviews of a 3* rating were given. how can I now plot this into a scatter graph? When I do it by highlighting the data it does this....
reviews | Jan-13 | Feb-13 | Mar-13 | Apr-13 | May-13 | Jun-13 | Jul-13 | Aug-13 | Sep-13 | Oct-13 | Nov-13 | Dec-13 | Jan-14 | Feb-14 | Mar-14 | Apr-14 | May-14 | Jun-14 | Jul-14 | Aug-14 | Sep-14 | Oct-14 | Nov-14 | Dec-14 | |
4* | 3 | x | x | x | |||||||||||||||||||||
2 | x | x | |||||||||||||||||||||||
1 | x | x | x | x | x | x | |||||||||||||||||||
reviews | Jan-13 | Feb-13 | Mar-13 | Apr-13 | May-13 | Jun-13 | Jul-13 | Aug-13 | Sep-13 | Oct-13 | Nov-13 | Dec-13 | Jan-14 | Feb-14 | Mar-14 | Apr-14 | May-14 | Jun-14 | Jul-14 | Aug-14 | Sep-14 | Oct-14 | Nov-14 | Dec-14 | |
3* | 3 | x | |||||||||||||||||||||||
2 | x | x | |||||||||||||||||||||||
1 | x | x | x | x | x | x | x |
<colgroup><col width="64" span="26" style="width:48pt"> </colgroup><tbody>
</tbody>
Please see that this data is for an example of a 4 and a 3* place. We then have number of reviews received per month. For example in March 2013 we received 1 3* review where as in April 2 reviews of a 3* rating were given. how can I now plot this into a scatter graph? When I do it by highlighting the data it does this....