Chart Question

[dhstein]

In a bar chart I can't find how to change the colors of the bars. Also I'd
like to put a label at the bottom of the chart. This is Excel 2007. Thanks
for any help on this.

 

[Jacob Skaria]

1. Click on the bar. From menu Home>Fill Color..
2. You can either just place a text box or can use a chart labeler add-in.

http://www.appspro.com/Utilities/ChartLabeler.htm

If this post helps click Yes

 

[RidgeView]

In a bar chart I can't find how to change the colors of the bars. Also I'd
like to put a label at the bottom of the chart. This is Excel 2007. Thanks
for any help on this.

A. Bar Colors:

1. Highlight the bars in your graph by clicking on one of them.
2. At the top of your worksheet select "Home/Font/Fill Color". 3. As you
run your mouse over the colors, the bars will change accordingly. 4. Stop
at the desired color.
B. Chart Label at bottom of graph:
1. Under the title "CHART TOOLS", select the tab "Layout/Axis
Title/Primary Horizontal Axis Title/Title Below Axis". 2. Change the
prompted area to what ever you call it.
REGARDS.....

 

[Shane Devenshire]

Hi,

1. Right-click the bar and choose Format Data Series, Fill tab, ...
for solid colors pick Solid fill or try the other goodies.
2. Choose Insert, Text Box click where you want the text box and start typing.