ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   side-by-side relative frequency bar graph (https://www.excelbanter.com/charts-charting-excel/158935-side-side-relative-frequency-bar-graph.html)

side-by-side relative frequency bar grap

side-by-side relative frequency bar graph
 
very basic statistics student. using excel how does one how to make a
side-by-side relative frequency bar graph? I know how to make a relative
frequency distribution bar graph but do not how to combine two of these into
one graph (side by side).
Thanks

Jon Peltier

side-by-side relative frequency bar graph
 
Are you looking for a tornado chart?

http://peltiertech.com/Excel/Charts/tornadochart.html

Even better would be a dot plot with two sets of markers:

http://peltiertech.com/Excel/Charts/DotPlot.html

The dot plot makes it easier to compare the values directly. A tornado moves
the values away from each other, and it's harder to tell which bar is
longer.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"side-by-side relative frequency bar grap" <side-by-side relative frequency
bar wrote in message
...
very basic statistics student. using excel how does one how to make a
side-by-side relative frequency bar graph? I know how to make a relative
frequency distribution bar graph but do not how to combine two of these
into
one graph (side by side).
Thanks





All times are GMT +1. The time now is 03:13 AM.

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