View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
StargateFanNotAtHome StargateFanNotAtHome is offline
external usenet poster
 
Posts: 13
Default Consistent colours between worksheet charts?

I have two pie charts, one for last fiscal year and one for this
fiscal year to-date. I haven't figured out how to get consistent
colours between the two, if that is even possible.

i.e., Office Supplies for last year show up as navy blue but this year
as dark brown. Contracts, long-form show up last year as a light
yellow and this year as a dark pink.

Is there a way to have any chart we make have the same colours, even
if it means manually assigning a colour per category?

Thanks! :oD