ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sr. Citien Question Re Bar Graph Plotting (https://www.excelbanter.com/excel-discussion-misc-queries/453757-sr-citien-question-re-bar-graph-plotting.html)

Bob[_19_]

Sr. Citien Question Re Bar Graph Plotting
 
Hello,

Using an older Excel. I think Excel 2007.
Am in my 80's now, so please bear with me a bit.

Have two columns of numbers, in columns A and B

Want to plot as a Bar Graph.

I can get it to look somewhat like a bar graph, but it
plots the horiz axis as row numbers.

I would like to be able to set up "bins"for, and have
the vertical going bars show how many numbers fall within each of the bins.

Just can't figure out how to do it.

Any help would be much appreciated.
Please be very specific and detailed. Hate to admit it,but it's harder
for me now at my age, it seems.

Also, assuming I can do this with your help, how can I get it to plot
a "distribution curve" also on the chart to see if the data is more or
less "normally distributed ?

Much thanks,
Appreciate any help,
Bob


All times are GMT +1. The time now is 01:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com