How to create chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

newby1273 - 29 Apr 2008 19:13 GMT

New questioner, please excuse....
I'm trying to create a chart. I have 4,000+ rows and only 1 column. I'm
trying to create what I term as a % chart. What percentage of the column is

>100, between 50 - 100, between 0 - 50, etc etc etc. Can anyone help direct

me? I don't know if this requires something else before being put into a
chart or what.

Reply to this Message

Mike Middleton - 29 Apr 2008 23:54 GMT

newby1273 -

A histogram (column chart of a frequency distribution) usually displays
frequencies, but you can easily change it to show percentages of total. If
you want a histogram, there are many alternatives.

One is the Histogram tool of Excel's Analysis ToolPak add-in. Another is my
Better Histogram add-in, available free at www.treeplan.com.

Or, you can create the frequency distribution using multiple COUNTIF
worksheet functions, the array-entered FREQUENCY function, or a pivot table.
Then create your own Column chart type.

If you search Google, you are likely to find other possibilities.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

> New questioner, please excuse....
> I'm trying to create a chart. I have 4,000+ rows and only 1 column. I'm
[quoted text clipped - 4 lines]
> me? I don't know if this requires something else before being put into a
> chart or what.

Reply to this Message