I have attached a small portion of a file that I am working on. It is a multi-year income statement that I have created a chart for.
Two questions please....
#1 Since the information that the chart is pulling from has a blank row in it (row 13), how do I get rid of it in the chart?
#2 What do I need to differently to make the chart update automatically when the number change in the statement?
It seems confusing to have revenue and expenses in the same chart. I'm thinking of maybe two. One to show yearly differences in total revenue, total expenses and net operating and one to show yearly department expenses differences.
Okay maybe that was three questions and they shouldn't all be in the same post.
Anything that anyone can contribute would be most appreciated.
D
Bookmarks