Home |
Search |
Today's Posts |
#1
|
|||
|
|||
In Excel 2003, the histograms are incorrect. Excel shows a bar gr.
When creating histograms using the "Data Analysis feature, Excel creates bar
graphs. Bar graphs are not histograms. Histograms bars share a boundary. They are used to chart interval and ration data. Bar graphs are used to graph nominal and ordinal data. |
#2
|
|||
|
|||
"Levi" wrote: When creating histograms using the "Data Analysis feature, Excel creates bar graphs. Bar graphs are not histograms. Histograms bars share a boundary. They are used to chart interval and ration data. Bar graphs are used to graph nominal and ordinal data. I agree with Harlan that if you are going to be doing a lot of graphing or statistics, you are better off with a dedicated program. However, if you right click on one of the bars, under Format Data Series, Options, you can set the gap width to 0. |
#3
|
|||
|
|||
Thanks Paul, I was looking for an option like that!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |