View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
[email protected] khers1350@gmail.com is offline
external usenet poster
 
Posts: 2
Default auto updating source data

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