Hi,
I am given the following data and asked to make a histogram
excel.JPG
I activated data analysis tab and I believe I understand how to do it with raw data. But I am unsure how to do it when the data is presented to me, as in the above mentioned picture.
Edit: corrected the attachment ("<1" is the correct picture)
If I understand correctly you want a column chart with no space between columns.
1) Select a cell in your table,
2) Insert column chart,
3) right click on a column on the chart and select 'Format Data Series',
4) slide the gap width slider all the way to the left (0%).
If you would like someone to make a chart with your data please upload the spreadsheet, not just a screenshot.
To upload a spreadsheet click on GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
That was exactly what I was looking for. Even though uploading the sheet itself is not needed now, I appreciate the information as reference for future tasks.
Feel free to mark this thread as [solved]
Glad that the solution works the way you want. Actually the original poster (OP) is the one who marks the thread as 'Solved', using the thread tools link above the first post in the thread, so as to prevent someone else from doing so unwarranted. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks