I searched the forum but couldn't find a solution. I have 5 categories of data --- revenue, exp 1, exp 2, exp 3, profit. I want to chart revenue and profit as a line and have the 3 expense fields be stacked columns connecting the 2 lines. The sum of the 3 stacked columns = the difference between revenue and profit.
Any help is greatly appreciated !!!
For example:
Period 1 Period 2 Period 3 Period 4 Period 5 Period 6 Plot as:
revenue 10,000 11,000 12,100 13,310 14,641 16,105 top line
exp 1 4,000 4,400 4,840 5,324 5,856 6,442 stacked column
exp 2 2,500 2,750 3,025 3,328 3,660 4,026 stacked column
exp 3 500 550 605 666 732 805 stacked column
profit 3,000 3,300 3,630 3,993 4,392 4,832 bottom line
Any help is greatly appreciated !!!
For example:
Period 1 Period 2 Period 3 Period 4 Period 5 Period 6 Plot as:
revenue 10,000 11,000 12,100 13,310 14,641 16,105 top line
exp 1 4,000 4,400 4,840 5,324 5,856 6,442 stacked column
exp 2 2,500 2,750 3,025 3,328 3,660 4,026 stacked column
exp 3 500 550 605 666 732 805 stacked column
profit 3,000 3,300 3,630 3,993 4,392 4,832 bottom line