Hi
I have a matrice that looks something like this:

A B
1 service 1000
2 maintenence 500
3 transport 300
4 service 200
5
6
7
8


and from this I like to make a pie-chart with procentage of the
costs.
The problem is that I never know
how many rows I will have and I would like to make my chart's source-
data updated automaticaly, so I would
have to specify it manually each time. Is this possible?


will be thankfull for any comments


tnx

Decide in advance the maximum number of rows you are likely to have
(eg 15) and set up your pie-chart from this. Then apply autofilter to
your costs column B.

When you import data in future just apply the filter by selecting "Non-
blanks", and your chart will then only make use of the real data.

Hope this helps.

Pete

On Feb 27, 10:06*am, khers1...@gmail.com wrote:
> Hi
> I have a matrice that looks something like this:
>
> * * * * A * * * * * * * B
> 1 * * * service * * * * 1000
> 2 * * * maintenence * * 500
> 3 * * * transport * * * * * * * * * * * 300
> 4 * * * service * * * * 200
> 5
> 6
> 7
> 8
>
> and from this I like to make a pie-chart with procentage of the
> costs.
> The problem is that I never know
> how many rows I will have and I would like to make my chart's source-
> data updated automaticaly, so I would
> have to specify it manually each time. Is this possible?
>
> will be thankfull for any comments
>
> tnx

See Stephen Bullen's site for a download.

http://www.oaltd.co.uk/Excel/Default.htm

FunChrt1 is a workbook showing how to create dynamic ranges for charting.

Or browse Tushar Mehta's site for dynamic charts.

http://www.tushar-mehta.com/excel/ne...rts/index.html


Gord Dibben MS Excel MVP

On Wed, 27 Feb 2008 02:06:01 -0800 (PST), (E-Mail Removed) wrote:

>Hi
>I have a matrice that looks something like this:
>
> A B
>1 service 1000
>2 maintenence 500
>3 transport 300
>4 service 200
>5
>6
>7
>8
>
>
>and from this I like to make a pie-chart with procentage of the
>costs.
>The problem is that I never know
>how many rows I will have and I would like to make my chart's source-
>data updated automaticaly, so I would
>have to specify it manually each time. Is this possible?
>
>
>will be thankfull for any comments
>
>
>tnx

On Feb 27, 6:11*pm, Gord Dibben <gorddibbATshawDOTca> wrote:
> See Stephen Bullen's site for a download.
>
> http://www.oaltd.co.uk/Excel/Default.htm
>
> FunChrt1 is a workbook showing how to create dynamic ranges for charting.
>
> Or browse Tushar Mehta's site for dynamic charts.
>
> http://www.tushar-mehta.com/excel/ne...rts/index.html
>
> Gord Dibben *MS Excel MVP
>
>
>
> On Wed, 27 Feb 2008 02:06:01 -0800 (PST), khers1...@gmail.com wrote:
> >Hi
> >I have a matrice that looks something like this:
>
> > * * * *A * * * * * * * B
> >1 * * * service * * * * 1000
> >2 * * * maintenence * * 500
> >3 * * * transport * * * * * * * * * * * 300
> >4 * * * service * * * * 200
> >5
> >6
> >7
> >8
>
> >and from this I like to make a pie-chart with procentage of the
> >costs.
> >The problem is that I never know
> >how many rows I will have and I would like to make my chart's source-
> >data updated automaticaly, so I would
> >have to specify it manually each time. Is this possible?
>
> >will be thankfull for any comments
>
> >tnx- Hide quoted text -
>
> - Show quoted text -

Thank you
I managed to look at the examples and make my own changes. But Before
I can make that Pie-chart I have to sum up the coloum, let me explain
I have these coloums

A B

Item1 2 000,00
Item2 1 000,00
Item3 3 000,00
Item1 1 500,00
Item4 2 300,00
Item2 1 000,00

Before making the chart I have to add all the Items (grouped) and get
something like this:

A B

Item1 3 500,00
Item2 2 000,00
Item3 3 000,00
Item4 2 300,00

Is there a smart way to group and add Items like that?
tnx again

Draw up a list of the individual items, eg from A25 onwards. Then in
B25 put this formula:

=SUMIF(A$1:A$20,A25,B$1:B$20)

Then copy this formula down as required.

Hope this helps.

Pete

On Feb 28, 12:22*pm, khers1...@gmail.com wrote:
> On Feb 27, 6:11*pm, Gord Dibben <gorddibbATshawDOTca> wrote:
>
>
>
>
>
> > See Stephen Bullen's site for a download.
>
> >http://www.oaltd.co.uk/Excel/Default.htm
>
> > FunChrt1 is a workbook showing how to create dynamic ranges for charting..
>
> > Or browse Tushar Mehta's site for dynamic charts.
>
> >http://www.tushar-mehta.com/excel/ne...rts/index.html
>
> > Gord Dibben *MS Excel MVP
>
> > On Wed, 27 Feb 2008 02:06:01 -0800 (PST), khers1...@gmail.com wrote:
> > >Hi
> > >I have a matrice that looks something like this:
>
> > > * * * *A * * * * * * * B
> > >1 * * * service * * * * 1000
> > >2 * * * maintenence * * 500
> > >3 * * * transport * * * * * * * * * * * 300
> > >4 * * * service * * * * 200
> > >5
> > >6
> > >7
> > >8
>
> > >and from this I like to make a pie-chart with procentage of the
> > >costs.
> > >The problem is that I never know
> > >how many rows I will have and I would like to make my chart's source-
> > >data updated automaticaly, so I would
> > >have to specify it manually each time. Is this possible?
>
> > >will be thankfull for any comments
>
> > >tnx- Hide quoted text -
>
> > - Show quoted text -
>
> Thank you
> I managed to look at the examples and make my own changes. But Before
> I can make that Pie-chart I have to sum up the coloum, let me explain
> I have these coloums
>
> A * * * * * * * * * * * * * * * * B
>
> Item1 * * * * * * * * *2 000,00
> Item2 * * * * * * * * * * * 1 000,00
> Item3 * * * * * * * * * * *3 000,00
> Item1 * * * * * * * * *1 500,00
> Item4 * * * * * * * * * * *2 300,00
> Item2 * * * * * * * * * * *1 000,00
>
> Before making the chart I have to add all the Items (grouped) and get
> something like this:
>
> A * * * * * * * * * * * * * * * * B
>
> Item1 * * * * * * * * *3 500,00
> Item2 * * * * * * * * * * * 2 000,00
> Item3 * * * * * * * * * * *3 000,00
> Item4 * * * * * * * * *2 300,00
>
> Is there a smart way to group and add Items like that?
> tnx again- Hide quoted text -
>
> - Show quoted text -

On Feb 28, 1:45*pm, Pete_UK <pashu...@auditel.net> wrote:
> Draw up a list of the individual items, eg from A25 onwards. Then in
> B25 put this formula:
>
> =SUMIF(A$1:A$20,A25,B$1:B$20)
>
> Then copy this formula down as required.
>
> Hope this helps.
>
> Pete
>
> On Feb 28, 12:22*pm, khers1...@gmail.com wrote:
>
>
>
> > On Feb 27, 6:11*pm, Gord Dibben <gorddibbATshawDOTca> wrote:
>
> > > See Stephen Bullen's site for a download.
>
> > >http://www.oaltd.co.uk/Excel/Default.htm
>
> > > FunChrt1 is a workbook showing how to create dynamic ranges for charting.
>
> > > Or browse Tushar Mehta's site for dynamic charts.
>
> > >http://www.tushar-mehta.com/excel/ne...rts/index.html
>
> > > Gord Dibben *MS Excel MVP
>
> > > On Wed, 27 Feb 2008 02:06:01 -0800 (PST), khers1...@gmail.com wrote:
> > > >Hi
> > > >I have a matrice that looks something like this:
>
> > > > * * * *A * * * * * * * B
> > > >1 * * * service * * * * 1000
> > > >2 * * * maintenence * * 500
> > > >3 * * * transport * * * * * * * * * * * 300
> > > >4 * * * service * * * * 200
> > > >5
> > > >6
> > > >7
> > > >8
>
> > > >and from this I like to make a pie-chart with procentage of the
> > > >costs.
> > > >The problem is that I never know
> > > >how many rows I will have and I would like to make my chart's source-
> > > >data updated automaticaly, so I would
> > > >have to specify it manually each time. Is this possible?
>
> > > >will be thankfull for any comments
>
> > > >tnx- Hide quoted text -
>
> > > - Show quoted text -
>
> > Thank you
> > I managed to look at the examples and make my own changes. But Before
> > I can make that Pie-chart I have to sum up the coloum, let me explain
> > I have these coloums
>
> > A * * * * * * * * * * * * * * * * B
>
> > Item1 * * * * * * * * *2 000,00
> > Item2 * * * * * * * * * * * 1 000,00
> > Item3 * * * * * * * * * * *3 000,00
> > Item1 * * * * * * * * *1 500,00
> > Item4 * * * * * * * * * * *2 300,00
> > Item2 * * * * * * * * * * *1 000,00
>
> > Before making the chart I have to add all the Items (grouped) and get
> > something like this:
>
> > A * * * * * * * * * * * * * * * * B
>
> > Item1 * * * * * * * * *3 500,00
> > Item2 * * * * * * * * * * * 2 000,00
> > Item3 * * * * * * * * * * *3 000,00
> > Item4 * * * * * * * * *2 300,00
>
> > Is there a smart way to group and add Items like that?
> > tnx again- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -

It did tnx

You're welcome.

Pete


On Feb 29, 10:35*am, khers1...@gmail.com wrote:
> On Feb 28, 1:45*pm, Pete_UK <pashu...@auditel.net> wrote:
>
>
>
>
>
> > Draw up a list of the individual items, eg from A25 onwards. Then in
> > B25 put this formula:
>
> > =SUMIF(A$1:A$20,A25,B$1:B$20)
>
> > Then copy this formula down as required.
>
> > Hope this helps.
>
> > Pete
>
> > On Feb 28, 12:22*pm, khers1...@gmail.com wrote:
>
> > > On Feb 27, 6:11*pm, Gord Dibben <gorddibbATshawDOTca> wrote:
>
> > > > See Stephen Bullen's site for a download.
>
> > > >http://www.oaltd.co.uk/Excel/Default.htm
>
> > > > FunChrt1 is a workbook showing how to create dynamic ranges for charting.
>
> > > > Or browse Tushar Mehta's site for dynamic charts.
>
> > > >http://www.tushar-mehta.com/excel/ne...rts/index.html
>
> > > > Gord Dibben *MS Excel MVP
>
> > > > On Wed, 27 Feb 2008 02:06:01 -0800 (PST), khers1...@gmail.com wrote:
> > > > >Hi
> > > > >I have a matrice that looks something like this:
>
> > > > > * * * *A * * * * * * * B
> > > > >1 * * * service * * * * 1000
> > > > >2 * * * maintenence * * 500
> > > > >3 * * * transport * * * * * * * * * * *300
> > > > >4 * * * service * * * * 200
> > > > >5
> > > > >6
> > > > >7
> > > > >8
>
> > > > >and from this I like to make a pie-chart with procentage of the
> > > > >costs.
> > > > >The problem is that I never know
> > > > >how many rows I will have and I would like to make my chart's source-
> > > > >data updated automaticaly, so I would
> > > > >have to specify it manually each time. Is this possible?
>
> > > > >will be thankfull for any comments
>
> > > > >tnx- Hide quoted text -
>
> > > > - Show quoted text -
>
> > > Thank you
> > > I managed to look at the examples and make my own changes. But Before
> > > I can make that Pie-chart I have to sum up the coloum, let me explain
> > > I have these coloums
>
> > > A * * * * * * * * * * * * * * * * B
>
> > > Item1 * * * * * * * * *2 000,00
> > > Item2 * * * * * * * * * * * 1 000,00
> > > Item3 * * * * * * * * * * *3 000,00
> > > Item1 * * * * * * * * *1 500,00
> > > Item4 * * * * * * * * * * *2 300,00
> > > Item2 * * * * * * * * * * *1 000,00
>
> > > Before making the chart I have to add all the Items (grouped) and get
> > > something like this:
>
> > > A * * * * * * * * * * * * * * * * B
>
> > > Item1 * * * * * * * * *3 500,00
> > > Item2 * * * * * * * * * * * 2 000,00
> > > Item3 * * * * * * * * * * *3 000,00
> > > Item4 * * * * * * * * *2 300,00
>
> > > Is there a smart way to group and add Items like that?
> > > tnx again- Hide quoted text -
>
> > > - Show quoted text -- Hide quoted text -
>
> > - Show quoted text -
>
> It did tnx- Hide quoted text -
>
> - Show quoted text -