The data in my series is sometime positive (> 0 ) and sometimes negative (< 0).
If there is a way to present the positive and negative data points in
different coloros
Thanks
--
Eli Kedar
Israel
The data in my series is sometime positive (> 0 ) and sometimes negative (< 0).
If there is a way to present the positive and negative data points in
different coloros
Thanks
--
Eli Kedar
Israel
Hi,
I have an explanation of how to make use of the Invert If negative option.
http://www.andypope.info/charts/Invertneg.htm
You may also find Jon's article on conditional charts useful.
http://peltiertech.com/Excel/Charts/...nalChart1.html
Cheers
Andy
Eli Kedar wrote:
> The data in my series is sometime positive (> 0 ) and sometimes negative (< 0).
> If there is a way to present the positive and negative data points in
> different coloros
>
> Thanks
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Thank you for the promt answer
--
Eli Kedar
Israel
"Andy Pope" wrote:
> Hi,
>
> I have an explanation of how to make use of the Invert If negative option.
> http://www.andypope.info/charts/Invertneg.htm
>
> You may also find Jon's article on conditional charts useful.
> http://peltiertech.com/Excel/Charts/...nalChart1.html
>
> Cheers
> Andy
>
> Eli Kedar wrote:
> > The data in my series is sometime positive (> 0 ) and sometimes negative (< 0).
> > If there is a way to present the positive and negative data points in
> > different coloros
> >
> > Thanks
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks