Subscribe
Hi, I'm creating an income tracking sheet. In the B column I will be inserting the sources of income, and in the C column I will be inserting the value ($5 etc). I want to be able to pull a pie chart (showing the % of each type of income source) from this that updates as more lines are added. There will be a limited number of income types which are already made into a list. How can I do this? Thanks in advance.
How to extract dynamic information
(2 posts) (2 voices)-
You can use tables or lists to do this.. or even OFFSET formula to make dynamic ranges. See here for help http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series
Posted 3 months ago #
Reply
You must log in to post.
