Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Levi
 
Posts: n/a
Default 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   Report Post  
Paul Hollinger
 
Posts: n/a
Default



"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   Report Post  
Levi
 
Posts: n/a
Default

Thanks Paul, I was looking for an option like that!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
sharing/using/saving Excel 2002 files in Excel 2003 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 07:27 PM
how to increase maximum number of columns in excel 2003 [email protected] Excel Discussion (Misc queries) 1 January 16th 05 08:13 PM
can a workbook with macros created in excel 2003 work in excel 20. Steve Venti Excel Discussion (Misc queries) 2 December 27th 04 02:31 PM
Excel 2000 file when opened in Excel 2003 generates errors? Doug Excel Discussion (Misc queries) 13 December 25th 04 10:20 PM


All times are GMT +1. The time now is 11:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"