View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
RohanSewgobind
 
Posts: n/a
Default Matching the colors Column Charts and Pie Charts


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?


--
RohanSewgobind
------------------------------------------------------------------------
RohanSewgobind's Profile: http://www.excelforum.com/member.php...o&userid=33724
View this thread: http://www.excelforum.com/showthread...hreadid=535065