Hi All i need help. i want to graphical representations on the data. Please help me what will be the best graphical representations and do for me
Hi All i need help. i want to graphical representations on the data. Please help me what will be the best graphical representations and do for me
You don't say what story you want your data to tell. How do you want the data to be read? What's the message?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi AliGW,
i want to represent the data in charts. Please help me what charts will be best to show. Can you do for me?
It sounds like your question is more about graphical representations in general and less about Excel. Part of the reason that there are so many different chart types (even more than are built into Excel) is because people have different things they want different charts to communicate. Since you have not expressed what you are trying to show or any other guidance about what kind of chart you want, it is difficult to give specific suggestions.
My first thought with that table is to use a clustered column chart with rows 2 to 3 as the horizontal/category axis data and rows 4 to 26 as the legend series. If you are unfamiliar with the basic steps to create a chart in Excel, I would suggest some introductory tutorials like these:
http://www.excel-easy.com/examples/column-chart.html
https://www.techonthenet.com/excel/c..._chart2016.php
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks