View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob[_19_] Bob[_19_] is offline
external usenet poster
 
Posts: 77
Default 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