# Charting cumulative values in histogram ?

1. ## Charting cumulative values in histogram ?

I have a set of numbers 1-12 along with a corresponding % that number occurs
in some data I'm analyzing.
What I want to plot is a histogram with number bin 1 - 12 along the x axis,
and on the yaxis a cumulative value of the total % 's upto that number.
So for simple case with 4 numbers
1, 20%
2, 40%
3, 30%
4, 10%

so the cumulative values I would like to histogram would be
1, 20 %
2, 60%
3, 90%
4,100%
I can't seem to get this to work via the histogram charting tool in the
Can anyone give me any pointers as to how to achieve this ?
Regards
Tony

2. ## RE: Charting cumulative values in histogram ?

TonyB,

Try setting your data up as follows:

a 20% 20%
b 40% 60%
c 30% 90%
d 10% 100%

Create a simple clustered column chart. Click once on the second series.
In the standard toolbar go to Chart ->Chart Type -> Line Chart -> OK.
You should now have one series represented by a line and one series
represented by a set of columns.

Next, click once on the line. Right-click on your mouse. Choose the
Selected Object option -> Axis -> Plot Series on Secondary Axis option.

----
Regards,
John Mansfield
http://www.pdbook.com

"TonyB" wrote:

> I have a set of numbers 1-12 along with a corresponding % that number occurs
> in some data I'm analyzing.
> What I want to plot is a histogram with number bin 1 - 12 along the x axis,
> and on the yaxis a cumulative value of the total % 's upto that number.
> So for simple case with 4 numbers
> 1, 20%
> 2, 40%
> 3, 30%
> 4, 10%
>
> so the cumulative values I would like to histogram would be
> 1, 20 %
> 2, 60%
> 3, 90%
> 4,100%
> I can't seem to get this to work via the histogram charting tool in the
> Can anyone give me any pointers as to how to achieve this ?
> Regards
> Tony
>
>
>

3. ## RE: Charting cumulative values in histogram ?

I put together a quick example - you can view it here:

http://www.pdbook.com/index.php/excel/simple_histogram/

----
Regards,
John Mansfield
http://www.pdbook.com

"John Mansfield" wrote:

> TonyB,
>
> Try setting your data up as follows:
>
> a 20% 20%
> b 40% 60%
> c 30% 90%
> d 10% 100%
>
> Create a simple clustered column chart. Click once on the second series.
> In the standard toolbar go to Chart ->Chart Type -> Line Chart -> OK.
> You should now have one series represented by a line and one series
> represented by a set of columns.
>
> Next, click once on the line. Right-click on your mouse. Choose the
> Selected Object option -> Axis -> Plot Series on Secondary Axis option.
>
>
> ----
> Regards,
> John Mansfield
> http://www.pdbook.com
>
> "TonyB" wrote:
>
> > I have a set of numbers 1-12 along with a corresponding % that number occurs
> > in some data I'm analyzing.
> > What I want to plot is a histogram with number bin 1 - 12 along the x axis,
> > and on the yaxis a cumulative value of the total % 's upto that number.
> > So for simple case with 4 numbers
> > 1, 20%
> > 2, 40%
> > 3, 30%
> > 4, 10%
> >
> > so the cumulative values I would like to histogram would be
> > 1, 20 %
> > 2, 60%
> > 3, 90%
> > 4,100%
> > I can't seem to get this to work via the histogram charting tool in the
> > tools/data analysis menu ?
> > Can anyone give me any pointers as to how to achieve this ?
> > Regards
> > Tony
> >
> >
> >

4. ## Re: Charting cumulative values in histogram ?

Hi John,
Thanks for the example, I can see how you do it now.
Regards
Tony

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1