If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can Excel draw a histogram with variable column widths
Trying to draw a histogram with various non equal age bands vs income,
neeed to do this as a histogram |
#2
|
|||
|
|||
Can Excel draw a histogram with variable column widths
Hi,
Enter the non-equal age-bands you want to use in a column. "Tools" -- "Data Analysis" -- "Histogram" -- "OK" -- select the range containing the income data for "Input Range" -- select the range containing the non-equal age-bands for "Bin Range" -- select a cell in an empty area for "Output Range" -- "OK" Please note that the "Data Analysis" Add-in should have been installed in Excel for this. You can also achieve the same results without using the add-in, by using COUNTIF or SUMPRODUCT functions. If you need help please reply to this post. Regards, B. R. Ramachandran "HB 44" wrote: Trying to draw a histogram with various non equal age bands vs income, neeed to do this as a histogram |
#3
|
|||
|
|||
Can Excel draw a histogram with variable column widths
HB 44 -
Trying to draw a histogram with various non equal age bands vs income, neeed to do this as a histogram You mention _two_ numerical variables: age and income. A histogram usually displays frequencies for ranges of a _single_ numerical variable. In Excel, a histogram usually is a Column chart type (vertical bars), and each bar has the same width. The horizontal axis has equal-width ranges of the numerical variable, and the frequency is shown by the height of the vertical bar. If you use the Histogram tool (Analysis ToolPak) and specify bin values that are not equally-spaced, Excel will create the frequency distribution correctly, but the Histogram chart will display equal-width bars representing your unequal-width ranges, so the Histogram chart will be distorted. FunChrt5.zip is available from Stephen Bullen's Excel Page, showing a way to get the appearance of unequal-width bars for a Column chart: http://www.bmsltd.ie/DLCount/DLCount...e=FunChrt5.zip Jon Peltier's Excel Chart Pages has general information about histograms: http://peltiertech.com/Excel/Charts/Histograms.html - Mike www.mikemiddleton.com |
#4
|
|||
|
|||
Can Excel draw a histogram with variable column widths
Here are more links to variable width column charts:
http://peltiertech.com/Excel/ChartsH...thColumns.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Mike Middleton" wrote in message ... HB 44 - Trying to draw a histogram with various non equal age bands vs income, neeed to do this as a histogram You mention _two_ numerical variables: age and income. A histogram usually displays frequencies for ranges of a _single_ numerical variable. In Excel, a histogram usually is a Column chart type (vertical bars), and each bar has the same width. The horizontal axis has equal-width ranges of the numerical variable, and the frequency is shown by the height of the vertical bar. If you use the Histogram tool (Analysis ToolPak) and specify bin values that are not equally-spaced, Excel will create the frequency distribution correctly, but the Histogram chart will display equal-width bars representing your unequal-width ranges, so the Histogram chart will be distorted. FunChrt5.zip is available from Stephen Bullen's Excel Page, showing a way to get the appearance of unequal-width bars for a Column chart: http://www.bmsltd.ie/DLCount/DLCount...e=FunChrt5.zip Jon Peltier's Excel Chart Pages has general information about histograms: http://peltiertech.com/Excel/Charts/Histograms.html - Mike www.mikemiddleton.com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Positioning Numeric Values Resulting from 6 Column Array Formula | Sam via OfficeKB.com | Worksheet Functions | 2 | January 5th, 2006 02:03 AM |
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | MEGTOM | New Users | 5 | October 27th, 2005 03:06 AM |
Excel column widths | Rachael | General Discussion | 6 | October 19th, 2005 09:08 PM |
retaining original column widths in excel | GCope | General Discussion | 0 | September 26th, 2005 06:43 PM |
Need to create a bar chart with variable column widths | Li | Charts and Charting | 1 | November 18th, 2003 06:03 PM |