auto updating source data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

khers1350@gmail.com - 27 Feb 2008 10:06 GMT

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

Reply to this Message

Pete_UK - 27 Feb 2008 10:38 GMT

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:
[quoted text clipped - 19 lines]
>
> tnx

Reply to this Message

Gord Dibben - 27 Feb 2008 17:11 GMT

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/newsgroups/dynamic_charts/index.html

Gord Dibben MS Excel MVP

>Hi
>I have a matrice that looks something like this:
[quoted text clipped - 19 lines]
>
>tnx

Reply to this Message

khers1350@gmail.com - 28 Feb 2008 12:22 GMT

> See Stephen Bullen's site for a download.
>
[quoted text clipped - 33 lines]
>
> - 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

Reply to this Message

Pete_UK - 28 Feb 2008 12:45 GMT

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:

> > See Stephen Bullen's site for a download.
>
[quoted text clipped - 62 lines]
>
> - Show quoted text -

Reply to this Message

khers1350@gmail.com - 29 Feb 2008 10:35 GMT

> Draw up a list of the individual items, eg from A25 onwards. Then in
> B25 put this formula:
[quoted text clipped - 77 lines]
>
> - Show quoted text -

It did tnx

Reply to this Message

Pete_UK - 29 Feb 2008 10:41 GMT

You're welcome.

Pete

On Feb 29, 10:35 am, khers1...@gmail.com wrote:

> > Draw up a list of the individual items, eg from A25 onwards. Then in
> > B25 put this formula:
[quoted text clipped - 81 lines]
>
> - Show quoted text -

Reply to this Message

Rate this thread: