Thread: Representing symbols in charts

I am trying to plot 2 series in a bar chart. Each observation can have a
numeric value of 0 to Infinity. The problem with this is that there is no way
I can represent 'Infinity' in the chart. I'd like to show a symbol whenever
there is an infinity, is there a way to out a symbol (eg. an infinity
symbol), other than by manually cutting and pasting it? Can someone help me
out?

Jon Peltier has an example of how to do this on his site:

http://www.peltiertech.com/Excel/Cha...ormatting.html


"Symbols in Charts" <Symbols in Charts@discussions.microsoft.com> wrote in
message news:34D97318-B30F-4BEE-830B-E46217071E3C@microsoft.com...
>I am trying to plot 2 series in a bar chart. Each observation can have a
> numeric value of 0 to Infinity. The problem with this is that there is no
> way
> I can represent 'Infinity' in the chart. I'd like to show a symbol
> whenever
> there is an infinity, is there a way to out a symbol (eg. an infinity
> symbol), other than by manually cutting and pasting it? Can someone help
> me
> out?