I have a file that contains three graphs. Two pie chats, one charting revenues and the other charting expenses, showing the contribution from each division of a department. At the top of the page i have a column chart graphing revenues and expenses together. The source data for all three charts is coming from the same data. I am trying to find a way to create a column chart that will use a different color for each division, like the pie chart does, instead of one color for revenues and one for expenses.
Is this Possible?