Help!

Pivot Chart Bar Chart?

  
  
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions RSS
Next:  Enabling VBA  
Author Message
Ken
External


Since: Sep 05, 2004
Posts: 347
PostPosted: Wed Nov 04, 2009 9:24 am    Post subject: Pivot Chart Bar Chart?
Archived from groups: microsoft>public>excel>misc (more info?)
Excel2003 ... Pivot Chart Bar Chart ... A Single Data Series with positive &
negative values.

Is it possible to format the "positive" & "negative" values with 2 different
pattern colors? ... positive one ... negative the other?) ... If so, how?

Thanks for the guidance ... Kha
Back to top
Jon Peltier
External


Since: Feb 01, 2004
Posts: 179
PostPosted: Wed Nov 04, 2009 7:40 pm    Post subject: Re: Pivot Chart Bar Chart? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
You could use "Invert if Negative"
http://peltiertech.com/Excel/ChartsHowTo/InvertIfNegative.html

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Ken wrote:
> Excel2003 ... Pivot Chart Bar Chart ... A Single Data Series with positive &
> negative values.
>
> Is it possible to format the "positive" & "negative" values with 2 different
> pattern colors? ... positive one ... negative the other?) ... If so, how?
>
> Thanks for the guidance ... Kha
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum