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

Yes and no.

while it is possible to create a bar chart with black/red colors, you're
going to need to create a second series to highlight the "red" numbers. The
more important questions to ask are "Why are some numbers red?" Is it pure
human randomness, or is there some logic? How is the data laid out (layout is
key to graph making in XL)? The problem with simply deciding some cells have
colors and others do not is that XL is not good at detecting color (is
possible with VB, but not 'handy'). It's much better at using rules/logic to
figure out what you want grouped.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"pcor" wrote:

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

All the numbers are blood pressure numbers. The black number indicate blood
pressure taken with NO unsual conditions applying. If the patient is
aggitatated or despondent, as we take the blood pressure, we input the number
in RED.
Does that help
Thanks

"Luke M" wrote:

Yes and no.

while it is possible to create a bar chart with black/red colors, you're
going to need to create a second series to highlight the "red" numbers. The
more important questions to ask are "Why are some numbers red?" Is it pure
human randomness, or is there some logic? How is the data laid out (layout is
key to graph making in XL)? The problem with simply deciding some cells have
colors and others do not is that XL is not good at detecting color (is
possible with VB, but not 'handy'). It's much better at using rules/logic to
figure out what you want grouped.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"pcor" wrote:

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