PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting How do I change the color of each bar in my graph?

Reply

How do I change the color of each bar in my graph?

 
Thread Tools Rate Thread
Old 13-11-2007, 06:05 PM   #1
=?Utf-8?B?TWVlbmll?=
Guest
 
Posts: n/a
Default How do I change the color of each bar in my graph?


When I click on the bar and go to "format data series" and change the color
of the bar, they all change. I want to change each individually, how to I
make them do that?
Thanks! Meenie
  Reply With Quote
Old 13-11-2007, 06:24 PM   #2
=?Utf-8?B?Sm9obiBNYW5zZmllbGQ=?=
Guest
 
Posts: n/a
Default RE: How do I change the color of each bar in my graph?

When you click on the bar, instead of clicking on it once click it twice.
Clicking on the bar twice should select the single bar. Then go ahead and
format it.

--
John Mansfield
http://cellmatrix.net





"Meenie" wrote:

> When I click on the bar and go to "format data series" and change the color
> of the bar, they all change. I want to change each individually, how to I
> make them do that?
> Thanks! Meenie

  Reply With Quote
Old 13-11-2007, 07:38 PM   #3
Jon Peltier
Guest
 
Posts: n/a
Default Re: How do I change the color of each bar in my graph?

Make sure that's two single clicks, not one double click.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"John Mansfield" <JohnMansfield@discussions.microsoft.com> wrote in message
news:2DBD5405-61E3-47BD-88EC-7538DA0EFB5A@microsoft.com...
> When you click on the bar, instead of clicking on it once click it twice.
> Clicking on the bar twice should select the single bar. Then go ahead and
> format it.
>
> --
> John Mansfield
> http://cellmatrix.net
>
>
>
>
>
> "Meenie" wrote:
>
>> When I click on the bar and go to "format data series" and change the
>> color
>> of the bar, they all change. I want to change each individually, how to I
>> make them do that?
>> Thanks! Meenie



  Reply With Quote
Old 15-11-2007, 07:11 PM   #4
=?Utf-8?B?TWVlbmll?=
Guest
 
Posts: n/a
Default Re: How do I change the color of each bar in my graph?

Thank you both so much! You've made my life much easier

"Jon Peltier" wrote:

> Make sure that's two single clicks, not one double click.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. - http://PeltierTech.com
> _______
>
>
> "John Mansfield" <JohnMansfield@discussions.microsoft.com> wrote in message
> news:2DBD5405-61E3-47BD-88EC-7538DA0EFB5A@microsoft.com...
> > When you click on the bar, instead of clicking on it once click it twice.
> > Clicking on the bar twice should select the single bar. Then go ahead and
> > format it.
> >
> > --
> > John Mansfield
> > http://cellmatrix.net
> >
> >
> >
> >
> >
> > "Meenie" wrote:
> >
> >> When I click on the bar and go to "format data series" and change the
> >> color
> >> of the bar, they all change. I want to change each individually, how to I
> >> make them do that?
> >> Thanks! Meenie

>
>
>

  Reply With Quote
Old 15-11-2007, 07:11 PM   #5
=?Utf-8?B?TWVlbmll?=
Guest
 
Posts: n/a
Default RE: How do I change the color of each bar in my graph?

Wow, such a simple answer! Thanks Following "help" I was clicking on the
bar then going up to the menu, clicking on something there, then clicking on
the color... And here it is so simple! Ah if help were only so good
Thanks a lot

"John Mansfield" wrote:

> When you click on the bar, instead of clicking on it once click it twice.
> Clicking on the bar twice should select the single bar. Then go ahead and
> format it.
>
> --
> John Mansfield
> http://cellmatrix.net
>
>
>
>
>
> "Meenie" wrote:
>
> > When I click on the bar and go to "format data series" and change the color
> > of the bar, they all change. I want to change each individually, how to I
> > make them do that?
> > Thanks! Meenie

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off