View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pcor pcor is offline
external usenet poster
 
Posts: 148
Default Color parts of a chart

I have some data on a spread sheet. Most of that data is in BLACK ink.
In certain cercumstances the data has to be enterred in RED INK.
Is there a way to SHOW that on a chart. In other words, I want to display
all the data in a BAR CHART; most of the data would show in black but I want
to have any data that is in RED ink on the spreedsheet show in a different
color on the bar chart.
Can it be done? How?
Thanks