ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   auto updating source data (https://www.excelbanter.com/charts-charting-excel/177830-auto-updating-source-data.html)

[email protected]

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



All times are GMT +1. The time now is 04:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com